Sql Server acess denied

[aquafin]

I use the following connection string , and i get an error -sql server exception:" SQL Server does not exist or access denied" When the databse exists on the local system i give server=(local) and it works, but when the databse reides on the other system it gives me the error.

Dim connect As SqlConnection = New SqlConnection("server=192.168.0.102;uid=sa;pwd=1234567890;database=elearning")

Where am i going wrong??

[aquafin]

i have registered with the remote sql server , but it says login failed for user 'sa' . Why is it so? I am sure i have given the correct userid and password

[RickCrone]

I use the following connection string , and i get an error -sql server exception:" SQL Server does not exist or access denied" When the databse exists on the local system i give server=(local) and it works, but when the databse reides on the other system it gives me the error.

Dim connect As SqlConnection = New SqlConnection("server=192.168.0.102;uid=sa;pwd=1234567890;database=elearning")

Where am i going wrong??

Maybe server name should be the computer name instead of ip address.

[dkautilya]

hi friends,

i face the same problem many days before, but the real issue is with the name of the server name u r passing. please pass the name the windows system server u r connecting to. it should be right. or also u check ur rights that u have acces to the specfic server or not.

[aquafin]

I tried giving the server name but it still gives me the error as:

Error description:{DBNETLIB]]ConnectionOpen(Connect()).} SQL Server does not exist or access denied

Can anyone tell me what does the above error mean? (DBNETLIB ???),
do i have to change any registry settings?

Thanks,

[rader.net]

you should use the sqlserver client tools to test whether you can connect to the database server at first.Maybe you dont have the access right or the database server's config should be checked

[RickCrone]

I use the following connection string , and i get an error -sql server exception:" SQL Server does not exist or access denied" When the databse exists on the local system i give server=(local) and it works, but when the databse reides on the other system it gives me the error.

Dim connect As SqlConnection = New SqlConnection("server=192.168.0.102;uid=sa;pwd=1234567890;database=elearning")

Where am i going wrong??

I'm using C# instead of VB but I don't think that should make a difference in the connection string. I don't have 'server' instead I have 'data source' and I don't have 'database' I have 'initial catalog'. You might try these changes OR you can use the server explorer and drag your table to your design view and let the IDE do the work for you (that will create your connection and your adapter. You can even just click on the adapter to generate a dataset if you want one.