how can i connect sql server on the network from my computer
i alreadyused connection string to connect another system but i am getting errors ,
tell me any sharing settings for sql server
Loading
how can i connect sql server on the network from my computer
i alreadyused connection string to connect another system but i am getting errors ,
tell me any sharing settings for sql server
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Kirtan PatelPosted Oct 23, 2008, 2:57 PM
Data Source=myServerAddress;Database=myDataBase;User ID=myUsername;Password=myPassword;Trusted_Connection=False;
and
Make Sure that U have Enabled "Remote Connection" In SQL Server Configurations
To Enable Remote Connection
Go To
SQL Server Surface Area Configuration>>Surface Area Conflagration For Services and Connection >>Remote Connections
Select "Using both TCP/IP or Named Pipe"
Restart SQL Server Service or Computer
Mamta MPosted Oct 23, 2008, 7:37 AM
hi,
The settings are different for different kinds of connections, for eg, a network server with SQL server authentication would have the following connection string:
connectionString= Data Source="Random";Initial Catalog="Finances";Integrated Security=SSPI;User ID=sa;Password=test;"
Hope that helps. If it doesn't solve your problem, then post the errors here so that depending on the error, you will get a solution.
-Mamta