"SQL Server does not exist or access denied" PPC

Hi everybody,
I have a great problem with Sql Server connections in Pocket Pc. When I try
to create a connection with an Sql Server 2000 with Visual Basic.NET 2003 (I
have Windows XP), I receive the error : "SQL Server does not exist or access
denied".
My connection string is something like:
Dim conn as new Sqlconnection("Server=NAMESERVER;Initial Catalog=Aname;User
ID=anID;Password=Apwd")
I've tried to make changes like Server=192.168.1..10 or change the user and
the password, or include the Integrated Security=SSPI with no success.
Could you help me, please?
I have found the solution by myself:
in the connection string, change the server name by his IP. Then
go to "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\SVRNETCN.exe"
and then enable TCP/IP (put TCP/IP in the right square).
Accept changes... Voil!
"Antonio Prados" <antonio.prados@.eutisoftware.com> escribi en el mensaje
news:35bsm3F4iukicU1@.individual.net...
> Hi everybody,
> I have a great problem with Sql Server connections in Pocket Pc. When I
try
> to create a connection with an Sql Server 2000 with Visual Basic.NET 2003
(I
> have Windows XP), I receive the error : "SQL Server does not exist or
access
> denied".
> My connection string is something like:
> Dim conn as new Sqlconnection("Server=NAMESERVER;Initial
Catalog=Aname;User
> ID=anID;Password=Apwd")
> I've tried to make changes like Server=192.168.1..10 or change the user
and
> the password, or include the Integrated Security=SSPI with no success.
> Could you help me, please?
>

"SQL Server does not exist or access denied" PPC

Hi everybody,
I have a great problem with Sql Server connections in Pocket Pc. When I try
to create a connection with an Sql Server 2000 with Visual Basic.NET 2003 (I
have Windows XP), I receive the error : "SQL Server does not exist or access
denied".
My connection string is something like:
Dim conn as new Sqlconnection("Server=NAMESERVER;Initial Catalog=Aname;User
ID=anID;Password=Apwd")
I've tried to make changes like Server=192.168.1..10 or change the user and
the password, or include the Integrated Security=SSPI with no success.
Could you help me, please?I have found the solution by myself:
in the connection string, change the server name by his IP. Then
go to "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\SVRNETCN.exe"
and then enable TCP/IP (put TCP/IP in the right square).
Accept changes... Voil!
"Antonio Prados" <antonio.prados@.eutisoftware.com> escribi en el mensaje
news:35bsm3F4iukicU1@.individual.net...
> Hi everybody,
> I have a great problem with Sql Server connections in Pocket Pc. When I
try
> to create a connection with an Sql Server 2000 with Visual Basic.NET 2003
(I
> have Windows XP), I receive the error : "SQL Server does not exist or
access
> denied".
> My connection string is something like:
> Dim conn as new Sqlconnection("Server=NAMESERVER;Initial
Catalog=Aname;User
> ID=anID;Password=Apwd")
> I've tried to make changes like Server=192.168.1..10 or change the user
and
> the password, or include the Integrated Security=SSPI with no success.
> Could you help me, please?
>

"Failed to generate a user instance of SQL Server" using sql server express and vwde. why?

I've set up a website on another computer using sql server express and visual web developer express, and it works as expected. However halfway through the development i've had to move to another computer. I installed visual web developer express + sql server express, and copied the project files across, but now when I attempt to run it I get the error:

Failed to generate a user instance of SQL Server due to afailure in starting the process for the user instance. The connectionwill be closed.

I've tried reinstalling the software and it doesn't help. Any idea why this is happening, and what I can do to fix it?

thanks

How to fix it is covered in the link below change the configuration. Hope this helps.

http://blog.krisvandermast.com/FailedToGenerateAUserInstanceOfSQLServerDueToAFailureInStartingTheProcessForTheUserInstanceTheConnectionWillBeClosed.aspx

|||

Hi,

I changed the built in account to 'local system' in the SQL server configuration manager, and deleted my SQLEXPRESS folder, then restarted the computer, but the same thing is happening. Is there anything else I need to do to fix this?

thanks for your help

|||

I am sorry you error sent me on the wrong track because moving a database created in one box and moving it to another is not a simple copying files over. That is the reason the solution I gave you did not fix your problem so delete the folder. When you are moving your database to a new computer you need to do it manually through code like the second link below. You need to check your access permissions to the new computer and follow the guide created by Microsoft in the second link if the forum posting in the first link below did not fix your problem. Hope this helps.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=125227&SiteID=1

http://support.microsoft.com/default.aspx?scid=kb;en-us;224071

"Failed to generate a user instance of SQL Server" - Redux

I have SQL Server 2005 SP1 Dev Edition installed on my laptop along with Visual Web Developer 2005. I installed SQL Server Express 2005 SP1. I then created a new web site using the Club Web Site template.

I did the recommended initial build to get the Membership database installed and got an error page (http://localhost:1667/WebSitesVB2/):

SQLExpress database file auto-creation error:
Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.

There were 4 recomme4ndations from the error page. I have met three of them: (1) the AppDaa folder that was created when I used the Club Web Site template; (2) my machine's ASPNET user set up with full control permissions on the APP Data Folder; (3) SQL Server Express successfully installed on my machine.

The 4th recommendation from the error page is "The process identity for the web server account must have a local user profile. See the readme document for details on how to create a local user profile for both machine and domain accounts. ". I have no idea of how to do this or how/where to find the elusive the "readme" file.

I am at a loss as to what to do next. I have spent the day going over forums on this error and none seem to provide consistent or relevant answers.

Try to remove User Instance=true from your connection string, if you don't need to generate a user instance at runtime. For more information about the user instance attribute, you can refer to:

http://msdn2.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.connectionstring(VS.80).aspx|||

Changed userinstance = TRUE to userinstance=FALSE. Same result - failure to generate userinstance.

Is it possible that there is some setting in VWD that provides a connection string for the ASPNET db that is to be created? The only connection string in the WebConfig from the original template is the one for the ClubSite DB. There is none for the ASPNET db (because the template does not provide the ASPNET DB.

After 2 tries, I still get this error and when I look at the database explorer, there is only one DB file: Club.MDF.

Anyone else have any answers?

|||

I probably should have included this stack trace:

Stack Trace:

[SqlException (0x80131904): Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.] System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +115 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +346 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +3244 System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +56 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +1084 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +272 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +355 System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) +91 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +115 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +122 System.Data.SqlClient.SqlConnection.Open() +229 System.Web.Management.SqlServices.GetSqlConnection(String server, String user, String password, Boolean trusted, String connectionString) +110[HttpException (0x80004005): Unable to connect to SQL Server database.] System.Web.Management.SqlServices.GetSqlConnection(String server, String user, String password, Boolean trusted, String connectionString) +181 System.Web.Management.SqlServices.SetupApplicationServices(String server, String user, String password, Boolean trusted, String connectionString, String database, String dbFileName, SqlFeatures features, Boolean install) +167 System.Web.Management.SqlServices.Install(String database, String dbFileName, String connectionString) +46 System.Web.DataAccess.SqlConnectionHelper.CreateMdfFile(String fullFileName, String dataDir, String connectionString) +681

---

|||Sorry I forgot to mention: there is a connection string named LocalSqlServer, which is used by .NET 2.0 built-in providers (Profile, Membership, RoleManager, etc.). You can override it and try again, for details you can refer to:
Configuring ASP.NET 2.0 Application Services to use SQL Server 2000 or SQL Server 2005