Connect to SQL Server

[Barry]

Hi

When trying to connect to SQL Server using the code below i get this message
at myConnection.Open() line

Login failed for user 'JACKSON-QS7MHO6H\ASPNET'

from where does it add \ASPNET
how do i log on

string mySelectQuery = "SELECT * FROM authors";
string myConnectString = "Persist Security Info=False;Integrated
Security=SSPI;database=pubs;server=JACKSON-QS7MHO6H;";
SqlCommand myCommand = new SqlCommand(mySelectQuery);
myCommand.Connection = new SqlConnection(myConnectString);

SqlConnection myConnection = new SqlConnection(myConnectString);
myCommand.CommandTimeout = 15;
myCommand.CommandType = CommandType.Text;
myConnection.Open();



Barry

 

[Juan T. Llibre]

Hi, Barry.

The issue you're seeing is that your database server doesn't
have a user named "JACKSON-QS7MHO6H\ASPNET"
with permissions to access the pubs database.

Since you're not specifying a username in your connection string,
the ASP.NET user is the one which attempts to login...and fails.

Add a user named "JACKSON-QS7MHO6H\ASPNET"
( that's "YourMachineName\ASPNET" ) to either SQL Server
or MSDE ( whichever you're using ) and give it permissions to
access the pubs database.

 

[Patrick Olurotimi Ige]

Barry you need ASPNET account to log into SQL SERVER(thats the ASPNET
WORK PROCESS ASP.NET uses).
Add ASPNET acct to your SQL server.
Hope that helps
Patrick

 

[Riki]

Hi

When trying to connect to SQL Server using the code below i get this
message at myConnection.Open() line

Login failed for user 'JACKSON-QS7MHO6H\ASPNET'

from where does it add \ASPNET
how do i log on

string mySelectQuery = "SELECT * FROM authors";
string myConnectString = "Persist Security Info=False;Integrated
Security=SSPI;database=pubs;server=JACKSON-QS7MHO6H;";
SqlCommand myCommand = new SqlCommand(mySelectQuery);
myCommand.Connection = new SqlConnection(myConnectString);

SqlConnection myConnection = new SqlConnection(myConnectString);
myCommand.CommandTimeout = 15;
myCommand.CommandType = CommandType.Text;
myConnection.Open();

Apart from allowing access to the ASPNET account (see
Juan's and Patrick's reply), you may also consider using
authentication and impersonation. This will make your
application run under the account that's logged on, and
if that account has access to your database, it will work.

Search Google for "ASP.NET impersonation".

 

[Barry]

Thanks all,

I Created a account in SQL Server and that solved the problem

Barry