SQL Server access across a network
-
Hi, I am running an application across a network which uses SQL server. When It runs I get an error 'Login failed for user guest' in the application. When I run the application on the machine where the server is it runs fine. How can I enable user access across a network to SQL Server? Thanks for any help.
-
Hi, I am running an application across a network which uses SQL server. When It runs I get an error 'Login failed for user guest' in the application. When I run the application on the machine where the server is it runs fine. How can I enable user access across a network to SQL Server? Thanks for any help.
Are you using a trusted connection? If so does the user you are logged in as on the remote machine have an account on the SQL Server?
Vogon Building and Loan advise that your planet is at risk if you do not keep up repayments on any mortgage secured upon it. Please remember that the force of gravity can go up as well as down.
-
Hi, I am running an application across a network which uses SQL server. When It runs I get an error 'Login failed for user guest' in the application. When I run the application on the machine where the server is it runs fine. How can I enable user access across a network to SQL Server? Thanks for any help.
Hi, If your using the SqlServer across the network you should not mention trusted connection = true if should specify as below myConnectionString = "Initial Catalog=Northwind;Data Source=servername;User ID=username;password=;Integrated Security=SSPI;"; thx. ramakrishna.j
-
Hi, If your using the SqlServer across the network you should not mention trusted connection = true if should specify as below myConnectionString = "Initial Catalog=Northwind;Data Source=servername;User ID=username;password=;Integrated Security=SSPI;"; thx. ramakrishna.j
The connection string i am using is as follows. sql_connection_string = "server=MICMACLAPTOP;Integrated Security=SSPI;database=humantouchSQL;Connect Timeout=20"; I have tried the below string sql_connection_string = "Initial Catalog=humantouchSQL;Data Source=MICMACLAPTOP;Integrated Security=SSPI;Connect Timeout=20"; But it still does not work. Any other suggestions?
-
The connection string i am using is as follows. sql_connection_string = "server=MICMACLAPTOP;Integrated Security=SSPI;database=humantouchSQL;Connect Timeout=20"; I have tried the below string sql_connection_string = "Initial Catalog=humantouchSQL;Data Source=MICMACLAPTOP;Integrated Security=SSPI;Connect Timeout=20"; But it still does not work. Any other suggestions?
-
The connection string i am using is as follows. sql_connection_string = "server=MICMACLAPTOP;Integrated Security=SSPI;database=humantouchSQL;Connect Timeout=20"; I have tried the below string sql_connection_string = "Initial Catalog=humantouchSQL;Data Source=MICMACLAPTOP;Integrated Security=SSPI;Connect Timeout=20"; But it still does not work. Any other suggestions?
-
Hi, I am running an application across a network which uses SQL server. When It runs I get an error 'Login failed for user guest' in the application. When I run the application on the machine where the server is it runs fine. How can I enable user access across a network to SQL Server? Thanks for any help.
If you're using a trusted connection, then make sure you log into the machine where you are running the app with an account that is also an account on the SQL Server database. (By your error message, it looks like you may have logged in as 'Guest.') To check this, on the SQL Server instance, check in the Security folder, and add your account to the list, and in the Database Access tab, check the database that this account needs to access. If you don't have rights to add a user to the server, then you will need to ask your DBA to do it for you.