How to connect via ODBC

Hi,

I would like to connect in SqlServer 2005 via ODBC SQLServer, how are the steps?

1 - How can I connect ODBC?

1.1 - I need SqlServer 2005 name - ok

1.2 - Which option should I take in order to login? Windows NT authentication or Sql Server authentication?

Which one is the best option?

Cheers,

Alessandro

1.2 - Which option should I take in order to login? Windows NT authentication or Sql Server authentication?

That depends - Windows authentication is almost always better but if you cannot use it then SQL Server authentication is fine as long as you have it enabled on the server and you have created a login on the server. With Windows authentication you can easily use existing Windows domains, groups and users, you don't have to create everything on the server and use extra login names and passwords.

What type of application are you using to connect to SQL Server? ODBC should be your last choice, rather use OLE DB or the .NET data provider if you can.

|||

Hi,

- I picked windows authentication. I can not use OLE DB from my application.

I've created one windows user and created one login, but I still getting "Not associated with a trusted SQL Server connection". I changed Surface Area configuration and Configuration Manager as well. I heard that I nedd to enable mix mode option, how can I do this?

thanks

|||

You haven't told me anything about your application or why you can't use OLE DB, so I'm guessing - but it sounds like you cannot use Windows authentication. In SQL Server Management Studio, right click your server and select Properties. Select the Security page, and on that page select the SQL Server and Windows Authentication mode radio button.

Then add a SQL Server login, and use that login and password in your connection string.

How to connect to msde on an other server?

I tried to connect to a msde on an other server via the enterprise manager.
This wasn't possible!
Unable to establish connection. Server unknown or access denied!
What can i do?
thx
Hi,
Can you enable the TCPIP protocol using the utility svrnetcn.exe from SQL
server machine. Run the
svrnetcn.exe from command prompt and after enabling the protocol stop and
start the MSSQL server Service .
After starting the service try connecting remotely
Thanks
Hari
SQL Server MVP
"Raupes" <Raupes@.discussions.microsoft.com> wrote in message
news:1055E5E7-0B98-4A3D-A303-8DA1C511FED4@.microsoft.com...
>I tried to connect to a msde on an other server via the enterprise manager.
> This wasn't possible!
> Unable to establish connection. Server unknown or access denied!
> What can i do?
> thx
|||Hi,
I have exactly the same problem. I have tried your
suggestion but without success.
Anyone have another suggestion?
Tks, Rui

>--Original Message--
>Hi,
>Can you enable the TCPIP protocol using the utility
svrnetcn.exe from SQL
>server machine. Run the
>svrnetcn.exe from command prompt and after enabling the
protocol stop and
>start the MSSQL server Service .
>After starting the service try connecting remotely
>
>--
>Thanks
>Hari
>SQL Server MVP
>
>"Raupes" <Raupes@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:1055E5E7-0B98-4A3D-A303-8DA1C511FED4@.microsoft.com...
enterprise manager.[vbcol=seagreen]
access denied!
>
>.
>
|||I had the same problem.
If you telnet to port 1433 on the machine running msde do you get a
connection failed message? If it fails it could be firewall settings.
I fixed the problem here by removing all protocols and then re-adding only
tcp/ip.
"Rui Oliveira" <anonymous@.discussions.microsoft.com> wrote in message
news:495b01c4c748$732788c0$a401280a@.phx.gbl...[vbcol=seagreen]
> Hi,
> I have exactly the same problem. I have tried your
> suggestion but without success.
> Anyone have another suggestion?
> Tks, Rui
> svrnetcn.exe from SQL
> protocol stop and
> message
> enterprise manager.
> access denied!
|||At first I had to configure the port at which the msde is listening.
After that I had to open the UDP 1434 port vor all wizzards of the
enterprise manager. Only god knows why the enterprise manager uses 1433 tcp
only and all other wizzards use 1434 udp.
hm.
hope that i could help you
cu
Raupes
"Rui Oliveira" wrote:

> Hi,
> I have exactly the same problem. I have tried your
> suggestion but without success.
> Anyone have another suggestion?
> Tks, Rui
> svrnetcn.exe from SQL
> protocol stop and
> message
> enterprise manager.
> access denied!
>

How to connect DB via ADSL

Please hellp me, I want connect DB via internet.Can you describe what you want in a bit more detail? It is really a bad idea to open up a database over the internet, you are just asking for trouble (and it will usually find you, quickly).

-PatPsql

how to configure biderectional transactional replication

Newb question: how to configure biderectional transactional replication in
sql server 2000
Message posted via http://www.droptable.com
http://support.microsoft.com/default...b;en-us;820675
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"jhon via droptable.com" <u6539@.uwe> wrote in message
news:54e46ef6eeff0@.uwe...
> Newb question: how to configure biderectional transactional replication
in
> sql server 2000
>
> --
> Message posted via http://www.droptable.com
|||Thanks, i tried it how ever i got an message while try to enable publishing
and distribution :
"The snapshot folder path , ..................\ReplData uses a special
share name which can usually be accessed only by login with administrative
privelege ... .. . . . .. .. "
what i do wrong, or maybe i miss something
Thank you
Hilary Cotter wrote:[vbcol=seagreen]
>http://support.microsoft.com/default...b;en-us;820675
Message posted via http://www.droptable.com
|||That shouldn't be a problem. Keep going through the wizard accepting
defaults.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"jhon via droptable.com" <u6539@.uwe> wrote in message
news:54e4eaf0aadfc@.uwe...
> Thanks, i tried it how ever i got an message while try to enable
> publishing
> and distribution :
> "The snapshot folder path , ..................\ReplData uses a
> special
> share name which can usually be accessed only by login with administrative
> privelege ... .. . . . .. .. "
> what i do wrong, or maybe i miss something
> Thank you
>
> Hilary Cotter wrote:
>
> --
> Message posted via http://www.droptable.com
|||Thanks, Hilary,
So if i understand right i create transactional replication on server1 add
subsciber server2, and
create transactional replication on server2 add subsciber server1.
and that it??
Hilary Cotter wrote:[vbcol=seagreen]
>That shouldn't be a problem. Keep going through the wizard accepting
>defaults.
>[quoted text clipped - 12 lines]
Imagination is more important them knowledge. (A.Einshtein)
Message posted via http://www.droptable.com
|||Yes, that's it. Make sure you follow the kb article to the letter. It is
really important you set the name conflicts section of the table articles
property to keep existing table unchanged.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"jhon via droptable.com" <u6539@.uwe> wrote in message
news:54e6217e3e998@.uwe...
> Thanks, Hilary,
> So if i understand right i create transactional replication on server1 add
> subsciber server2, and
> create transactional replication on server2 add subsciber server1.
> and that it??
>
> Hilary Cotter wrote:
> --
> Imagination is more important them knowledge. (A.Einshtein)
>
> Message posted via http://www.droptable.com

how to config server as a Distributor

how to config server as a Distributor?
thnx
Message posted via http://www.webservertalk.comBook online has details on this:
http://msdn.microsoft.com/library/e...pl_sph_2so9.asp
-oj
"zizi via webservertalk.com" <forum@.nospam.webservertalk.com> wrote in message
news:dea0c44760714273b90e28953aeac4c1@.SQ
webservertalk.com...
> how to config server as a Distributor?
> thnx
> --
> Message posted via http://www.webservertalk.com