February 1, 2006 at 5:01 pm
i need to build a client that connect in local to the mssql on my server,
i've tried to use the standard connection string, the same i use in the web site, but it doesn't work,
which string connection i have to use? and how to setup the sql server in order to allow client connections?
February 1, 2006 at 6:11 pm
What version of SQL Server 2005?
The reason i ask is that the developer edition e.g. is not network enabled by default so you have to enable TCP/IP and express is the same.
So if you could tell us what version that would be good.
If its developer, evaluation or express launch the sql server configuratiion manager and go to sql server 2005 network configuration and prortocols and then make sure tcp/ip is enabled. Also go to the surface area configuration tool and ensure that in the remote connections bit that it is set to allow both local and remote connections.
hth
David
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply