connection string
-
Hi Everybody, I have Visual Studio 2005 and SQL Server 2005 installed on my PC which runs on Windows XP PE.The problem is when I finished the setup of SQL Srver 2005 it was not getting connected using SQL Server Authentication, so I used windows authentication.Now I developed an application it is running on my PC but whenever I am running it using IIS the connection can not be established with SQL Server.What can be wrong? how can i create a user with password on SQL Server? Also if i create this application fully fuctionable on my machine then at the time of deployment will it create any problem on the remote server? One last point:Can anyone give me a sample connection string for remote server.I know it for my PC only but what parameters i have to give when connecting to a remote database and how?
-
Hi Everybody, I have Visual Studio 2005 and SQL Server 2005 installed on my PC which runs on Windows XP PE.The problem is when I finished the setup of SQL Srver 2005 it was not getting connected using SQL Server Authentication, so I used windows authentication.Now I developed an application it is running on my PC but whenever I am running it using IIS the connection can not be established with SQL Server.What can be wrong? how can i create a user with password on SQL Server? Also if i create this application fully fuctionable on my machine then at the time of deployment will it create any problem on the remote server? One last point:Can anyone give me a sample connection string for remote server.I know it for my PC only but what parameters i have to give when connecting to a remote database and how?
if u have user id and pwd then use the following: Data Source=urServerAddress;Initial Catalog=urDataBase;User Id=myUsername;Password=myPassword; if u r using windows authentication then use the following: Data Source=urServerAddress;Initial Catalog=urDataBase;Integrated Security=SSPI;
Abdul Sami, Systems Analyst
-
Hi Everybody, I have Visual Studio 2005 and SQL Server 2005 installed on my PC which runs on Windows XP PE.The problem is when I finished the setup of SQL Srver 2005 it was not getting connected using SQL Server Authentication, so I used windows authentication.Now I developed an application it is running on my PC but whenever I am running it using IIS the connection can not be established with SQL Server.What can be wrong? how can i create a user with password on SQL Server? Also if i create this application fully fuctionable on my machine then at the time of deployment will it create any problem on the remote server? One last point:Can anyone give me a sample connection string for remote server.I know it for my PC only but what parameters i have to give when connecting to a remote database and how?
Clickety[^] You will need to change the connection types allowed to both integrated & sql standard. Create an application specific standard identity in SQL server, give it adequate rights to your database (not sa and probably not DBO). We have a script that grants execute on all procs and select on all tables & views. Use the standard creds in the connection string you decide to use!
Never underestimate the power of human stupidity RAH