error with sql 2005 express

G

Guest

i want to migrate one of my projects from sql server 2000 to 2005. I have
scripted one of the databases i use with the sql enterprise manager and
executed the script with some minor modifications to a sql server 2005
express, everything work good but when i try to connect from a .net app i get
the error "login failed. the user 'dimilio is not associated with a trusted
SQL server connection" and dimilio of course is the username with which i am
trying to connect, this user was created with the script i executed to the
server. Does anybody knows what is this error about?

Thanks in advance
 
R

Rogas69

hi, you should configure server to support mixed authentication or use
windows authentication to connect. also check if you transferred logins from
old dbms

peter
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using SMO for SQL Server 2008 Express AND SQL Server 2005 Express 6
Sql Server Express won't let me connect 8
problem adding connection in vs 2005 sql 2005 express 2
webservice - dsn - sql server 1
Install SQL Server 2005 Express With ClickOnce? 1
Cannot connect a remote sql server 9
SQL Server 2005 throught OLEDB : Named parameter problem ? 3
Dot Net 2.0 or SQL Server 2005 problem? 10

Top