SQL Server 2005 problem - simple :)

  • The_torst
  • Graduate
  • Graduate
  • The_torst
  • Posts: 216
  • Loc: Denmark

Post 3+ Months Ago

Hi guys,

I just installed SQL server 2005, but I can't connect to it from my ASP pages; I think it's got to do with the username I enter in the connection string.

When I set up the server, I had to use Windows Authentication - but I need to make it work with username and password from the connection string. Any ideas as to how to do this? I looked through millions of posts, but none of them had any relevant info :?

Btw: I created a "sa" user, that lets me log in from a query analyzer of some sort; but I can't use that username and password from my asp pages, apparently.

Thanks for any help!
  • Anonymous
  • Bot
  • No Avatar
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post 3+ Months Ago

  • ATNO/TW
  • Super Moderator
  • Super Moderator
  • User avatar
  • Posts: 23456
  • Loc: Woodbridge VA

Post 3+ Months Ago

If I'm following you correctly, use your sa account to add an existing domain user and assign them rights to the database. Then use the domain user to connect instead of sa. If you have to use Windows authentication, remember sa is not a Domain user. Personally, I would have your Network Administrator create a user account specifically for your SQL databases, then simply use that one.

Follow the instructions here and it will probably solve your problem:
http://www.devx.com/tips/Tip/13156 (older article - but might still work)

or this
http://support.microsoft.com/kb/247931
  • The_torst
  • Graduate
  • Graduate
  • The_torst
  • Posts: 216
  • Loc: Denmark

Post 3+ Months Ago

Thanks a lot ATNO, I'll try this today and post the outcome :)

Post Information

  • Total Posts in this topic: 3 posts
  • Users browsing this forum: No registered users and 15 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
 

© 1998-2014. Ozzu® is a registered trademark of Unmelted, LLC.