Can't connect to sqlserver 2005 express

Question

Can't connect to sqlserver 2005 express

allendehl

SSC Enthusiast

Points: 100
More actions
April 23, 2008 at 10:03 am

#185648

Hi friends,
I'm trying to connect to a SQLEXPRESS db in my local PC and I have
done every possible think and google search and I had no luck so far.
The last thing I did was create a ASPNET login(associated to the
ASPNET user in the local computer) to connect using it. This is my
connection string:
Data Source=localhost\SQLEXPRESS;Initial
Catalog=whitest_production;User Id=ASPNET;Password=
Sometimes I get the following error:
A connection was successfully established with the server, but then an
error occurred during the login process.
After that I start to get: Loggin Failed for user ASPNET
I'm getting crazy here...please help.
Thanks

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

bledu SSChampion Points: 12335 More actions · Answer 1

can you connect successfully if you use the management studio ?what if you use windows authentication are you able to connect?

Everything you can imagine is real.

GSquared SSC Guru Points: 260824 More actions · Answer 2

When you installed SQL Server, what login(s) did you create? Or did you tell it to use Windows authentication only?

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

allendehl SSC Enthusiast Points: 100 More actions · Answer 3

Yes I can connect using Management Studio Express using Windows Auth or SQL Auth usinh the sa user.

I have both Authentications, windows and SQL

At this point what I need is to be able to connect to the DB. I dont care about security or users. I'm running the DB in my local PC and at the bottom line it will go to a real SQL server, so I will take care of the security later.

Any idea of how can I connect to my DB with any user?

I tried sa and it says login failed too.

bledu SSChampion Points: 12335 More actions · Answer 4

can you check in your System Event Log or the Application Event Log? are there any entries that are suspicious related to your app?

Everything you can imagine is real.

GSquared SSC Guru Points: 260824 More actions · Answer 5

In that case, is the user and password in your connection string set up correctly? Does it match a valid user, who has rights to the database you're trying to connect to?

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

allendehl SSC Enthusiast Points: 100 More actions · Answer 6

Thank you very much everyone.

I finally decided to install my db in a remote server using regular SQL. Now I'm connected and working!!

The issue was obviously with SQL Express

Thanks u again