help asp.net,web.config,connectionstring
-
Hi, I have an application that has been developed mysomebody else and i want to continue developing it... It has the following connectionstring < name="abc1" connectionString="Data Source=SERVER\SQLEXPRESS;Initial Catalog=abc;Integrated Security=True" providerName="System.Data.SqlClient" /> in web.config file; As i understand it, the database is stored on server and database name is abc, now when i try accessing the server from sql server 2005, it would not access. what should i enter in server txtbox, authentication textbox and the above statement doesn't show any username, so is there any username or password... please provide help, Thanx, haseeb
haseeb
-
Hi, I have an application that has been developed mysomebody else and i want to continue developing it... It has the following connectionstring < name="abc1" connectionString="Data Source=SERVER\SQLEXPRESS;Initial Catalog=abc;Integrated Security=True" providerName="System.Data.SqlClient" /> in web.config file; As i understand it, the database is stored on server and database name is abc, now when i try accessing the server from sql server 2005, it would not access. what should i enter in server txtbox, authentication textbox and the above statement doesn't show any username, so is there any username or password... please provide help, Thanx, haseeb
haseeb
Hi, First, note that it uses a named instance (SQLEXPREESS) , so when you try to connect the server you need to specify all (SERVER\SQLEXPRESS) Second, it is using Integrated Security, so, seems you dont need any specific user/password information. And yes, the database name is : abc :suss::thumbsup:
-
Hi, I have an application that has been developed mysomebody else and i want to continue developing it... It has the following connectionstring < name="abc1" connectionString="Data Source=SERVER\SQLEXPRESS;Initial Catalog=abc;Integrated Security=True" providerName="System.Data.SqlClient" /> in web.config file; As i understand it, the database is stored on server and database name is abc, now when i try accessing the server from sql server 2005, it would not access. what should i enter in server txtbox, authentication textbox and the above statement doesn't show any username, so is there any username or password... please provide help, Thanx, haseeb
haseeb
Use server explorer of visual studio/database explorer of visual web developer Right Click Data Connections -> Add Connection Server Name= IP Address of the remote server [must be static IP] SQl Authentication: User Name = type in user name who has authentication Password = type your password Click on Test Connection, it will work. If test not succeed then try to ping the IP Address from command prompt. If not pings, its networking fault. and if it works then check permissions of the server.
-
Hi, I have an application that has been developed mysomebody else and i want to continue developing it... It has the following connectionstring < name="abc1" connectionString="Data Source=SERVER\SQLEXPRESS;Initial Catalog=abc;Integrated Security=True" providerName="System.Data.SqlClient" /> in web.config file; As i understand it, the database is stored on server and database name is abc, now when i try accessing the server from sql server 2005, it would not access. what should i enter in server txtbox, authentication textbox and the above statement doesn't show any username, so is there any username or password... please provide help, Thanx, haseeb
haseeb