Wrox Programmer Forums
|
ASP E-commerce As of Oct 5, 2005, this forum is now locked. No posts have been deleted. Please use "Classic ASP Professional" at: http://p2p.wrox.com/forum.asp?FORUM_ID=56 for discussions similar to the old ASP Pro Code Clinic or one of the other many remaining ASP and ASP.NET forums here.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP E-commerce section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old December 5th, 2003, 03:10 PM
Authorized User
 
Join Date: Oct 2003
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Yeh i just installed msde!!!



 
Old December 5th, 2003, 03:19 PM
Imar's Avatar
Wrox Author
 
Join Date: Jun 2003
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Right. The MSDE doesn't come with management tools. There are basically three ways to overcome that:

1. Use command line tools to create or manage users
2. Use T-SQL statements to create users. Use sprocs like sp_addlogin and sp_grantdbaccess to create logins for your database. Search this forum for sp_addlogin for more info.
3. Download the trial version of SQL Server. It comes with client tools that don't expire, if I am not mistaken. I am not sure whether your license gives you permissions to use the tools after the trial period, so you'll need to check that with Microsoft.

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.





Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL Server Connection and Database Problem workib C# 1 November 13th, 2008 03:26 PM
Database connection with SQL Server yubaraj JSP Basics 3 May 29th, 2007 04:39 AM
Failed to copy objects from SQL server to SQL Serv monfu SQL Server 2000 4 December 4th, 2005 05:54 PM
Database connection failed after SP2 Ned VB Databases Basics 0 August 31st, 2004 02:59 PM
Sql server connection failed AcidHell2 All Other Wrox Books 0 February 26th, 2004 01:57 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.