C# Programming
11-10-2009, 06:11 AM
On one machine [A] in local network there is SQL server 2005 express installed.
The connection string is:
"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\dbs\database.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"
I need to connect to that db from another machine [B] on the local network.
I changed . to SQL server machine IP. But got Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON' error
I also tried to add User Id=myUserName;Password=myPassword but have the same error with user name and password of the user on machine [A]
How to provide access from machine [B] to the SQL server on machine [A]
I'm coding C# service application, not ASP.NET site
????????
The connection string is:
"Data Source=.\SQLEXPRESS;AttachDbFilename=C:\dbs\database.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"
I need to connect to that db from another machine [B] on the local network.
I changed . to SQL server machine IP. But got Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON' error
I also tried to add User Id=myUserName;Password=myPassword but have the same error with user name and password of the user on machine [A]
How to provide access from machine [B] to the SQL server on machine [A]
I'm coding C# service application, not ASP.NET site
????????