Last post Jun 04, 2007 05:02 PM by Lav.Pathak
May 31, 2007 04:34 PM|WC123|LINK
ahhh.. I have a really dumb question. How can I setup the connection string for a MSSQL 2005 with the personal site ? it's not lcoated onthe same box and does use a SQL userid and password. THanks !!!
May 31, 2007 04:52 PM|Lav.Pathak|LINK
If it does not work
They have everything on a connection string. I am sure you will find a connection string you want.
May 31, 2007 05:00 PM|e_screw|LINK
Hi, and welcome to ASP.NET Forums
Check this link for connectionString settings
connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true"
The data source attribute specifies the location of your database. If your database is on another server, just provide the IP address of that server as the data source.
May 31, 2007 07:53 PM|WC123|LINK
thanks... this is the connection string in the example and that seems to be for a file attachment not a remote database...
thanks all the same though!!
May 31, 2007 07:57 PM|WC123|LINK
thanks a bunch... the website is awesome too!!!
Jun 04, 2007 05:02 PM|Lav.Pathak|LINK
If your issue is resolved then please mark this thread as answered.