Wrong credentials used on DB connection

Jun 26, 2012 at 12:14 PM

Hi

 

I'm having trouble during setup. I have changed the connection string to use the sa user, but it seems that SlickTicket tries to use the logged on user.

My connection string looks like this:

<add name="SlickTicket" connectionString="Data Source=dbserver\SQLEXPRESS;Initial Catalog=SlickTicket;user id=sa;password=password;" providerName="System.Data.SqlClient"/>

However I get this error message during setup (/setup/active_directory.aspx)

Cannot open database "SlickTicket" requested by the login. The login failed.
Login failed for user 'DOMAIN\user'.

I also changed the connectionstring in app.config in the DomainModel and copied the dll to WebUI/bin

 

What am I doing wrong?

Coordinator
Jun 26, 2012 at 3:18 PM

Is your SQL Server instances set up to allow SQL authentication?

Jun 26, 2012 at 6:31 PM
Edited Jun 26, 2012 at 7:39 PM

Yes.

The first step (create tables) of setup worked fine.

 

Edit: Somehow it doesnt use the credentials I entered in the web.config and the app.config.

 

PS: Impressive work :-)