Wrox Programmer Forums
|
SQL Server 2005 General discussion of SQL Server *2005* version only.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2005 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 March 21st, 2007, 01:39 AM
Registered User
 
Join Date: Mar 2007
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default SQL SERVER EXPRESS

I insatlled an instance of SQL express on my machine and then i installed my applicaion (developed in VB.net) ...its working fine. Then I handover the machine to the actual user..when this user login with his login ID and try to run the application it fails. What settings can be done in order to run the applicaion so that any user if try to run the application with his/her ID.

rohit
 
Old March 21st, 2007, 08:44 AM
Authorized User
 
Join Date: Dec 2006
Posts: 57
Thanks: 0
Thanked 0 Times in 0 Posts
Default

What is the exact error message? That will help narrow down the issue.

Quite possibly a security issue...
There are three groups that are default logins after installation that the 'users' need to be a member of.
BUILTIN\Administrators
BUILTIN\Users
<machinename>\mahcinename\SQLServer2005MSSQLUser$< machinename>$SQLEXPRESS

If the user cannot be a member of one of the groups, they will need to have a sql login manually added.

Adam Gossage
Lake Wylie, SC, USA





Similar Threads
Thread Thread Starter Forum Replies Last Post
Upgrade SQL Express to SQL Server timeware SQL Server 2005 2 August 27th, 2007 02:37 PM
VB Express and SQL server on remote server questio HoosierDaddy61 Visual Basic 2005 Basics 0 February 22nd, 2006 11:27 AM
Accessing a SQL Server Express DB thru VB Express djelavic SQL Server 2005 2 February 21st, 2006 07:53 PM
Connecting to SQL Server Express venkikrao VB.NET 3 February 4th, 2006 12:00 AM





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