Posted by Dan Guzman on 10/02/35 11:54

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_addrolemember 'WebRole', 'user01'

--
Hope this helps.

Dan Guzman
SQL Server MVP

"kito" <juri.strumpflohner@gmail.com> wrote in message
news:1154517199.822958.63630@p79g2000cwp.googlegroups.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.Environment.GetEnvironmentVariable("computername")
> connectionString = "workstation id=""" & workstation & """;packet
> size=4096;user id=user01;integrated security=SSPI;data source=""" &
> workstation & "\SQLExpress"";persist security info=True;initial
> catalog=webshop"
> connection = New SqlConnection(connectionString)
>
> 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
>

[Back to original message]