Problems when trying to build Connection to SQL Server Express from ASP.NET application

[kito]

Hi,
I have a problem, when I want to access to my SQL Server Express
database from my ASP.NET application.
My workstation ID is KITOLAP-HP
My username is user01

Now I built the following connection String (VB.NET):
Dim workstation As String =
System.Environm ent.GetEnvironm entVariable("co mputername")
connectionStrin g = "workstatio n id=""" & workstation & """;packet
size=4096;user id=user01;integ rated security=SSPI;d ata source=""" &
workstation & "\SQLExpress""; persist security info=True;initi al
catalog=webshop "
connection = New SqlConnection(c onnectionString )

Although I put as user id "user01" the application makes an error when
I try to open the connection, saying that the login with user "aspnet"
failed.

How can I change it so that as login-user "user01" is taken and not
"aspnet" or otherwise, how can I create a new user in the SQL Server
database with which I could access the DB??

thanks,
kito

[Dan Guzman]

Re: Problems when trying to build Connection to SQL Server Express from ASP.NET application

Your connection string contains a mix of both SQL authentication and Windows
authentication methods. For SQL authentication, specify User ID and
Password and omit the Integrated Security keyword. For Windows
Authentication, specify only Integrated Security=SSPI and omit the User ID
and Password so that the Windows process identity is used.

How can I change it so that as login-user "user01" is taken and not
"aspnet" or otherwise, how can I create a new user in the SQL Server
database with which I could access the DB??

It looks like you want to use SQL Authentication so specify 'user01' and the
corresponding password as described above. Below is a script to add the
login to SQL Server and corresponding database user:

USE webshop
GO
CREATE LOGIN user01 WITH PASSWORD = 'mypassword';
CREATE USER user01;
GO

Note that you'll also need to grant object permissions to complete your
security configuration. The Best Practice is to grant permissions only to
roles so that you can easily control access via role membership. For
example:

--setup security on each object
CREATE ROLE WebRole;
GRANT EXECUTE ON dbo.MyProc TO WebRole;

--assign users to role(s)
EXEC sp_addrolemembe r 'WebRole', 'user01'

--
Hope this helps.

Dan Guzman
SQL Server MVP

"kito" <juri.strumpflo hner@gmail.comw rote in message
news:1154517199 .822958.63630@p 79g2000cwp.goog legroups.com...

Hi,
I have a problem, when I want to access to my SQL Server Express
database from my ASP.NET application.
My workstation ID is KITOLAP-HP
My username is user01
>
Now I built the following connection String (VB.NET):
Dim workstation As String =
System.Environm ent.GetEnvironm entVariable("co mputername")
connectionStrin g = "workstatio n id=""" & workstation & """;packet
size=4096;user id=user01;integ rated security=SSPI;d ata source=""" &
workstation & "\SQLExpress""; persist security info=True;initi al
catalog=webshop "
connection = New SqlConnection(c onnectionString )
>
Although I put as user id "user01" the application makes an error when
I try to open the connection, saying that the login with user "aspnet"
failed.
>
How can I change it so that as login-user "user01" is taken and not
"aspnet" or otherwise, how can I create a new user in the SQL Server
database with which I could access the DB??
>
thanks,
kito
>