Problem with connection to sqlserver

[ABudair]

Dear all,

I'm trying to connect to sqlserver db by drag the table into the web form i have but all the time a message told me that

Login faild to server "servername\'Aspnet' "


and i'm sure that the server name is correct.

any help please.

[mahesh18]

go to SQL Server enterprise manager-->Microsoft SQL Servers-->SQL Server Group-->Local-->Security-->Logins
Now right click to Logins and click to New Login. Click the side by button of Name and add ASPNET.
Go to Propertise of Server_Name\ASPNET and go to server roles and check for system administration. say ok. thats it

cheers

Mahesh

[ABudair]

Thanx alot my friend i hope that the luck will be always with you.

bye....

Abudair