Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
BOOK: Beginning Visual Basic 2005 Databases ISBN: 978-0-7645-8894-5
This is the forum to discuss the Wrox book Beginning Visual Basic 2005 Databases by Thearon Willis; ISBN: 9780764588945
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Beginning Visual Basic 2005 Databases ISBN: 978-0-7645-8894-5 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
  #1 (permalink)  
Old May 27th, 2006, 03:54 AM
Registered User
 
Join Date: Jan 2006
Location: Columbus, Ohio, USA.
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to gwapojoe
Default DB Migration and SQL Express 2005

Is the connection not working because I'm using SQL Express 2005 or something else. Because it does not work for me.

I used the SQL Server Management Studio Express and gave myself all rights everywhere, still didn't let me login.

GwapoJoe@columbus.rr.com
  #2 (permalink)  
Old May 29th, 2006, 01:29 PM
Thearon's Avatar
Wrox Author
 
Join Date: Dec 2003
Location: Fuquay Varina, NC, USA.
Posts: 396
Thanks: 0
Thanked 8 Times in 8 Posts
Default

I just replied to this other post which may offer a solution to the problem you are having. http://p2p.wrox.com/topic.asp?TOPIC_ID=44780

Thearon
  #3 (permalink)  
Old May 29th, 2006, 01:42 PM
Registered User
 
Join Date: Jan 2006
Location: Columbus, Ohio, USA.
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to gwapojoe
Default

I found the same thing, it was disabled.
I enabled it and am at the stage to figure out how to restart it.

One thing though, I have been using windows Authentication, does this matter regarding the login based on your DB migration?

Feeling a little lost here.

ps. Suggestion, having a place to capture video of problem and submit for review, and have your post back the fix. What you think?

GwapoJoe@columbus.rr.com
  #4 (permalink)  
Old May 30th, 2006, 06:21 AM
Thearon's Avatar
Wrox Author
 
Join Date: Dec 2003
Location: Fuquay Varina, NC, USA.
Posts: 396
Thanks: 0
Thanked 8 Times in 8 Posts
Default

While in SQL Server Configuration Manager, click on SQL Server 2005 Services in the tree node and then in the display list, right click on SQL Server and choose Restart from the context menu. This will restart SQL Server 2005.

You can use either SQL Server Authentication or Windows Authentication for the examples in the book.

Thearon


Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL 2005 Express DBs in MSE or App_Data/db Explore cJeffreywang SQL Server ASP 0 February 13th, 2008 10:32 PM
MSDE or SQL 2005 EXPRESS? angelboy C# 2005 2 June 19th, 2007 12:10 AM
connect to SQL EXPRESS 2005 angelboy C# 2005 0 June 8th, 2007 01:34 PM
SQL Express 2005 Tremmorkeep BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 2 July 20th, 2006 04:38 PM
Accessing a SQL Server Express DB thru VB Express djelavic SQL Server 2005 2 February 21st, 2006 07:53 PM





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