• RSS
  • Twitter
  • FaceBook

Security Forums

Log in

FAQ | Usergroups | Profile | Register | RSS | Posting Guidelines | Recent Posts

SQL - MSDE Problems

Users browsing this topic:0 Security Fans, 0 Stealth Security Fans
Registered Security Fans: None
Post new topic   Reply to topic   Printer-friendly version    Networking/Security Forums Index -> Programming and More

View previous topic :: View next topic  
Author Message
Chozen1
Just Arrived
Just Arrived


Joined: 21 Apr 2002
Posts: 0
Location: NW, UK

Offline

PostPosted: Fri Nov 29, 2002 5:56 pm    Post subject: SQL - MSDE Problems Reply with quote

Hi all,

Im currently having to setup a Web/DB connection for an application Im developing. I have to create a set of ASP pages for interaction with a SQLServer DB.

My current OS is Win2K Professional on which MS SQLServer 2000 will not install as it requires a minimum of Windows 2K Server edition. So I have managed to install the MSDE. This for some strange reason has failed to install the Enterprise manager. But the engine seems to run OK.

I created the pages, setup the DB as a simple demo, and created the dsn connection. All tests have been successful.

However the login fails. Its looking for a login for the account USR_Jon_PB this needs to be created in SQL to make it work. How can I create this account without having the enterprise manager.

Thank You

Chozen1
Back to top
View user's profile Send private message Send e-mail
ToddK
Just Arrived
Just Arrived


Joined: 29 Nov 2002
Posts: 0
Location: Ottawa, Canada

Offline

PostPosted: Fri Nov 29, 2002 5:58 pm    Post subject: Reply with quote

On the SQL Server 2000 is there a developer edition. Most disks have this developer edition. It will install on a regular workstation. You should install it. it will give you the Enterprise amanger and other tools like the query analyzer.
Back to top
View user's profile Send private message Visit poster's website
Chozen1
Just Arrived
Just Arrived


Joined: 21 Apr 2002
Posts: 0
Location: NW, UK

Offline

PostPosted: Fri Nov 29, 2002 6:08 pm    Post subject: Reply with quote

I cant see it, its not an option on the menus and it doesn't look like its on the CD I have been given.

Chozen1
Back to top
View user's profile Send private message Send e-mail
ToddK
Just Arrived
Just Arrived


Joined: 29 Nov 2002
Posts: 0
Location: Ottawa, Canada

Offline

PostPosted: Fri Nov 29, 2002 6:11 pm    Post subject: Reply with quote

Try this:
http://www.msde.biz/
Back to top
View user's profile Send private message Visit poster's website
Chozen1
Just Arrived
Just Arrived


Joined: 21 Apr 2002
Posts: 0
Location: NW, UK

Offline

PostPosted: Fri Nov 29, 2002 6:17 pm    Post subject: Reply with quote

How will this Query tool help me ?

Chozen1
Back to top
View user's profile Send private message Send e-mail
ToddK
Just Arrived
Just Arrived


Joined: 29 Nov 2002
Posts: 0
Location: Ottawa, Canada

Offline

PostPosted: Fri Nov 29, 2002 6:24 pm    Post subject: Reply with quote

D'oh, sorry it won't. I forgot the problem.

I think that if you install the enterprise manager then you can connect to MDSE. I can't remember where to get the Manager though.

*edit* someone else here might know, there 68 to our near 800 gives us the advantage Smile */edit*
Back to top
View user's profile Send private message Visit poster's website
ToddK
Just Arrived
Just Arrived


Joined: 29 Nov 2002
Posts: 0
Location: Ottawa, Canada

Offline

PostPosted: Fri Nov 29, 2002 11:59 pm    Post subject: Reply with quote

It looks like Microsoft doesn't have an install of the Enterprise Manager. What you can do is download a 120 day evaluation copy of the developer edition of SQL Server then use the Manager from that sfter you have installed it.
Back to top
View user's profile Send private message Visit poster's website
ToddK
Just Arrived
Just Arrived


Joined: 29 Nov 2002
Posts: 0
Location: Ottawa, Canada

Offline

PostPosted: Sat Nov 30, 2002 12:06 am    Post subject: Reply with quote

As a fast solution you should look to see if you can create the account with a SQL statement.
Back to top
View user's profile Send private message Visit poster's website
ToddK
Just Arrived
Just Arrived


Joined: 29 Nov 2002
Posts: 0
Location: Ottawa, Canada

Offline

PostPosted: Sat Nov 30, 2002 2:59 am    Post subject: Reply with quote

You can also use Access to connect to MSDE.
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   

Post new topic   Reply to topic   Printer-friendly version    Networking/Security Forums Index -> Programming and More All times are GMT + 2 Hours
Page 1 of 1


 
Jump to:  
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 vote in polls in this forum

Looking for more Windows Networking info?

Sign up to the WindowsNetworking.com Monthly Newsletter, written by Enterprise Security MVP Deb Shinder, containing news, the hottest tips, Networking links of the month and much more. Subscribe today and don't miss a thing!
View a sample newsletter.

Become a WindowsNetworking.com member!

Discuss your Windows Networking issues with thousands of other Windows Newtorking experts. Click here to join!

Community Area

Log in | Register

Readers' Choice

Which is your preferred data recovery solution?

Follow TechGenix on Twitter