Error: Could not connect to database

The following error is encountered while trying to Host the site from IIS ..
" The Assembly Version ([ASSEMBLY VERSION]) does not match the Database Version ([DATABASE VERSION]).
"Error: Could not connect to the database specified in the connection string for SqlDataProvider. "

We have 2 different machines, over which we have 2 different SQL Server.
In Web.Config, if we give server=server1 it works well and there is no problem at all...
if we give server=server2, and executehttp://localhost/application, the above mentioned error occurs..

and yes the application is hosted on 3rd machine......

Can anyone throw some light on this regard.
Its urgent.

You're using DotNetNuke, right? Try this search on the Forums to see other threads on this topic:
http://forums.asp.net/search/SearchResults.aspx?q=ASSEMBLY+VERSION+match+DATABASE+VERSION&o=Relevance

Error: can not connect to the database

Hello
First of all, let me tell you, I have no knowledge of SQL server at all. We
have an SQL Server 2005 that has been installed by an external company. I
have installed a new database on it, using the default settings that were
displayed on my screen.
When I try to connect to the database (I'm a domain administrator),
everything works just fine. If an end user tries the same the following erro
r
is shown of the screen:
Error: can not connect to the database. ConnectionString:
Provider=SQLOLEDB.1; Integrated Security Info=False;Inital
Catalog=ZeugnisManager2006; Data Source=RBS-W11
I'm almost sure that my end user needs some additional rights to have to be
declared in the SQL console... but when I try to add a domain user in the
permissions option, the object isn't recognized... I checked that the Window
s
Authentication is allowed on the SQL server, so I really do not know where t
o
start from now...
Please help me, knowing you should explain it as simply as possible... I
have no idea of SQL Server...
Thanks
NicolasThey need to set Integrated Security =True in their connection string, and
make sure that the nt account they are connecting with can logon to SQL
Serve rand have a db acconut which has rights to the database.
Either that or they should use SQL Authentication with a SQL Account.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Nicolas Heyer" <NicolasHeyer@.discussions.microsoft.com> wrote in message
news:B2AC3BE8-9947-4B3D-99B3-22D7094B3635@.microsoft.com...
> Hello
> First of all, let me tell you, I have no knowledge of SQL server at all.
> We
> have an SQL Server 2005 that has been installed by an external company. I
> have installed a new database on it, using the default settings that were
> displayed on my screen.
> When I try to connect to the database (I'm a domain administrator),
> everything works just fine. If an end user tries the same the following
> error
> is shown of the screen:
> Error: can not connect to the database. ConnectionString:
> Provider=SQLOLEDB.1; Integrated Security Info=False;Inital
> Catalog=ZeugnisManager2006; Data Source=RBS-W11
> I'm almost sure that my end user needs some additional rights to have to
> be
> declared in the SQL console... but when I try to add a domain user in the
> permissions option, the object isn't recognized... I checked that the
> Windows
> Authentication is allowed on the SQL server, so I really do not know where
> to
> start from now...
> Please help me, knowing you should explain it as simply as possible... I
> have no idea of SQL Server...
> Thanks
> Nicolas

Error: can not connect to the database

Hello
First of all, let me tell you, I have no knowledge of SQL server at all. We
have an SQL Server 2005 that has been installed by an external company. I
have installed a new database on it, using the default settings that were
displayed on my screen.
When I try to connect to the database (I'm a domain administrator),
everything works just fine. If an end user tries the same the following error
is shown of the screen:
Error: can not connect to the database. ConnectionString:
Provider=SQLOLEDB.1; Integrated Security Info=False;Inital
Catalog=ZeugnisManager2006; Data Source=RBS-W11
I'm almost sure that my end user needs some additional rights to have to be
declared in the SQL console... but when I try to add a domain user in the
permissions option, the object isn't recognized... I checked that the Windows
Authentication is allowed on the SQL server, so I really do not know where to
start from now...
Please help me, knowing you should explain it as simply as possible... I
have no idea of SQL Server...
Thanks
NicolasThey need to set Integrated Security =True in their connection string, and
make sure that the nt account they are connecting with can logon to SQL
Serve rand have a db acconut which has rights to the database.
Either that or they should use SQL Authentication with a SQL Account.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Nicolas Heyer" <NicolasHeyer@.discussions.microsoft.com> wrote in message
news:B2AC3BE8-9947-4B3D-99B3-22D7094B3635@.microsoft.com...
> Hello
> First of all, let me tell you, I have no knowledge of SQL server at all.
> We
> have an SQL Server 2005 that has been installed by an external company. I
> have installed a new database on it, using the default settings that were
> displayed on my screen.
> When I try to connect to the database (I'm a domain administrator),
> everything works just fine. If an end user tries the same the following
> error
> is shown of the screen:
> Error: can not connect to the database. ConnectionString:
> Provider=SQLOLEDB.1; Integrated Security Info=False;Inital
> Catalog=ZeugnisManager2006; Data Source=RBS-W11
> I'm almost sure that my end user needs some additional rights to have to
> be
> declared in the SQL console... but when I try to add a domain user in the
> permissions option, the object isn't recognized... I checked that the
> Windows
> Authentication is allowed on the SQL server, so I really do not know where
> to
> start from now...
> Please help me, knowing you should explain it as simply as possible... I
> have no idea of SQL Server...
> Thanks
> Nicolassql

Error: can not connect to the database

Hello
First of all, let me tell you, I have no knowledge of SQL server at all. We
have an SQL Server 2005 that has been installed by an external company. I
have installed a new database on it, using the default settings that were
displayed on my screen.
When I try to connect to the database (I'm a domain administrator),
everything works just fine. If an end user tries the same the following error
is shown of the screen:
Error: can not connect to the database. ConnectionString:
Provider=SQLOLEDB.1; Integrated Security Info=False;Inital
Catalog=ZeugnisManager2006; Data Source=RBS-W11
I'm almost sure that my end user needs some additional rights to have to be
declared in the SQL console... but when I try to add a domain user in the
permissions option, the object isn't recognized... I checked that the Windows
Authentication is allowed on the SQL server, so I really do not know where to
start from now...
Please help me, knowing you should explain it as simply as possible... I
have no idea of SQL Server...
Thanks
Nicolas
They need to set Integrated Security =True in their connection string, and
make sure that the nt account they are connecting with can logon to SQL
Serve rand have a db acconut which has rights to the database.
Either that or they should use SQL Authentication with a SQL Account.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Nicolas Heyer" <NicolasHeyer@.discussions.microsoft.com> wrote in message
news:B2AC3BE8-9947-4B3D-99B3-22D7094B3635@.microsoft.com...
> Hello
> First of all, let me tell you, I have no knowledge of SQL server at all.
> We
> have an SQL Server 2005 that has been installed by an external company. I
> have installed a new database on it, using the default settings that were
> displayed on my screen.
> When I try to connect to the database (I'm a domain administrator),
> everything works just fine. If an end user tries the same the following
> error
> is shown of the screen:
> Error: can not connect to the database. ConnectionString:
> Provider=SQLOLEDB.1; Integrated Security Info=False;Inital
> Catalog=ZeugnisManager2006; Data Source=RBS-W11
> I'm almost sure that my end user needs some additional rights to have to
> be
> declared in the SQL console... but when I try to add a domain user in the
> permissions option, the object isn't recognized... I checked that the
> Windows
> Authentication is allowed on the SQL server, so I really do not know where
> to
> start from now...
> Please help me, knowing you should explain it as simply as possible... I
> have no idea of SQL Server...
> Thanks
> Nicolas

error: 25 - Connection string is not valid -- HELP Please!

I have been having a problem trying to connect to a SQL Server. I have installed the Developer edition on an MS Small Business edition 2003 server

I also installed MS Sql Manager and I was able to create a database and connect to it. The database server is in the same PC. I used the surface configuration to enable remote connections using TCP /IP and pipe lines.

My application runs without a problem on my development machine but when I deployed on this server I get theprovider: SQL Network Interfaces, error: 25 - Connection string is not valid Error.

this is my config file setup

<connectionStrings>
<add name="Diamond_dbConnectionString" connectionString="Data Source=192.168.1.104\MSSQLSERVER;Initial Catalog=Diamond_db;Integrated Security=True"
providerName="System.Data.SqlClient" />
</connectionStrings>

I have google and yahoo this error I found a lot of information I've tried many of them but still having the problem. I will appreciate your help solving this problem. I have a customer waiting since last week to see this site and I'm still stuck.

Tia

Charles

PS. Below I pasted the complete error info I get.

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid)

Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details:System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid)

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException (0x80131904): An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid)] System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +734995 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188 System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup) +820 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +359 System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28 System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +424 System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66 System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +496 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +82 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105 System.Data.SqlClient.SqlConnection.Open() +111 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +121 System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) +162 System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) +107 DiamondTableAdapters.COUNTRIES_TEMPLATETableAdapter.GetContriesTemplate() +108[TargetInvocationException: Exception has been thrown by the target of an invocation.] System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) +0 System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) +72 System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks) +296 System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) +29 System.Web.UI.WebControls.ObjectDataSourceView.InvokeMethod(ObjectDataSourceMethod method, Boolean disposeInstance, Object& instance) +482 System.Web.UI.WebControls.ObjectDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +2040 System.Web.UI.WebControls.BaseDataList.GetData() +53 System.Web.UI.WebControls.DataList.CreateControlHierarchy(Boolean useDataSource) +284 System.Web.UI.WebControls.BaseDataList.OnDataBinding(EventArgs e) +56 System.Web.UI.WebControls.BaseDataList.DataBind() +72 System.Web.UI.WebControls.BaseDataList.EnsureDataBound() +55 System.Web.UI.WebControls.BaseDataList.CreateChildControls() +63 System.Web.UI.Control.EnsureChildControls() +87 System.Web.UI.Control.PreRenderRecursiveInternal() +41 System.Web.UI.Control.PreRenderRecursiveInternal() +161 System.Web.UI.Control.PreRenderRecursiveInternal() +161 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1360

---

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42

Do you have ISA running on the server? Can you connect through Server Manager to the server using the same credentials?

Jeff

|||

Jeff,

I'm using EMS SQL Manager for SQL Server

http://sqlmanager.net/products/mssql/manager/

to create and manage my SQL server. I can connect to the server using windows credentials but when I try with the ASP application I can't

Thanks

Charles

|||

Is the ASP.NET app using the same Windows account to access the database, or is it using the ASP.NET process account?

Jeff

|||

Jeff,

Honestly I'm very green regarding ASP.NET and MS-SQL Server

When I installed the server I asigned the Windows account to gain access to the SQL Server. When I created the database in question I also used the Windows Account.

When I registered the database with MS Server manager tool I also used the same Windows Account.

How can I check If I'm using the ASP.NET process account instead of the Windows Account?

I will appreciate your inputs.

Tia

Charles

|||

The ASP.NET process account, unless you have set it or changed it, is ASPNET or NETWORK SERVICE depending on operatiing system. It is unlikely you chose this account for access to SQL. But normally you would get a mdifferent error if that was the problem.

Take a look at connectionstrings.com for some possibilities in changing your connection string. You may want to use a standard authentication with SQL user and password rather than rely on a trusted connection.

Is your SQL on a different server than the web server? I wouldn't think so but you use the IP address of the SQL server in your connection. You should just need to enable TCP/IP, which you said you've done.

Jeff

|||Are you sure the MSSQLSERVER is the name of the named (not default) instance? It seems to be the SQL service name of default instance. If you're trying to connect to a default SQL instance on a remote server, just set the Data Source to the IP address of the remote server is ok.sql

Error: 18456, Severity: 14, State: 16. Login failed for user

Hello.

I get this error when I try to connect to my SQL Server with JDBC:

Excepcion en MyPool Pool.getNewConnection() [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Cannot open database "lituania" requested by the login. The login failed.

And in the ERRORLOG I get:

2002-02-22 19:59:46.62 Logon Error: 18456, Severity: 14, State: 16.

2002-02-22 19:59:46.62 Logon Login failed for user 'frontend'. [CLIENT: 10.0.0.75]

I found it is supossed to be a password mismatch:

http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx

but I checked the password is correct.

Any ideas? Thank you in advance.

State: 16

It means the login does not have permissions to log into the target database, i.e. lituania in your case.

This is also indicated by the error msg: --> Cannot open database "lituania" requested by the login. The login failed.

So, please make sure you grant access privilige to "frontend".

|||Been there / done that. Maybe I'm not granting the access priviledge correctly.

What I do is right-clicking over the lituania database within the Microsoft SQL Server Management Studio Express. Then I go to Properties -> Permissions -> Users or roles: frontend -> Explicit permissions for frontend: (and in the Grant column I grant actually everything) -> OK

Still the same problem.

Please help.|||Hi,

navigate through Security > Logins > Properties > User Mapping > Choose the Database > Map the user to the database (you will see that he will get the public role by default)

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||I did that and then checked db_accessadmin (that was unchecked) and leave public checked (anyway I cannot uncheck it). Then I pressed OK and got the message:

Create failed for user 'frontend'. (Microsoft.SqlServer.Express.Smo)
Additional information:
An exception ocurred while executing a Transact-SQL statement or batch, (Microsoft.SqlServer.Express.ConnectionInfo)
User, group or role 'frontend' already exists in the current database. (Microsoft SQL Server, Error: 15023)

Any ideas?|||moving to SQL Security forum. Somebody should be able to help you.|||

I got the same problem. May anyone help me to solve this?

Thanks a lot!

|||

You should check the database permissions catalog for database 'lituania', to verify that the user 'frontend' is actually granted access permissions to the database.

Thanks
Laurentiu

Error: 18456, Severity: 14, State: 16. Login failed for user

Hello.

I get this error when I try to connect to my SQL Server with JDBC:

Excepcion en MyPool Pool.getNewConnection() [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Cannot open database "lituania" requested by the login. The login failed.

And in the ERRORLOG I get:

2002-02-22 19:59:46.62 Logon Error: 18456, Severity: 14, State: 16.
2002-02-22 19:59:46.62 Logon Login failed for user 'frontend'. [CLIENT: 10.0.0.75]

I found it is supossed to be a password mismatch:

http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx

but I checked the password is correct.

Any ideas? Thank you in advance.

State: 16

It means the login does not have permissions to log into the target database, i.e. lituania in your case.

This is also indicated by the error msg: --> Cannot open database "lituania" requested by the login. The login failed.

So, please make sure you grant access privilige to "frontend".

|||Been there / done that. Maybe I'm not granting the access priviledge correctly.

What I do is right-clicking over the lituania database within the Microsoft SQL Server Management Studio Express. Then I go to Properties -> Permissions -> Users or roles: frontend -> Explicit permissions for frontend: (and in the Grant column I grant actually everything) -> OK

Still the same problem.

Please help.
|||Hi,

navigate through Security > Logins > Properties > User Mapping > Choose the Database > Map the user to the database (you will see that he will get the public role by default)

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||I did that and then checked db_accessadmin (that was unchecked) and leave public checked (anyway I cannot uncheck it). Then I pressed OK and got the message:

Create failed for user 'frontend'. (Microsoft.SqlServer.Express.Smo)
Additional information:
An exception ocurred while executing a Transact-SQL statement or batch, (Microsoft.SqlServer.Express.ConnectionInfo)
User, group or role 'frontend' already exists in the current database. (Microsoft SQL Server, Error: 15023)

Any ideas?
|||moving to SQL Security forum. Somebody should be able to help you.|||

I got the same problem. May anyone help me to solve this?

Thanks a lot!

|||

You should check the database permissions catalog for database 'lituania', to verify that the user 'frontend' is actually granted access permissions to the database.

Thanks
Laurentiu

sql

Error: 18456, Severity: 14, State: 16. Login failed for user

Hello.

I get this error when I try to connect to my SQL Server with JDBC:

Excepcion en MyPool Pool.getNewConnection() [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Cannot open database "lituania" requested by the login. The login failed.

And in the ERRORLOG I get:

2002-02-22 19:59:46.62 Logon Error: 18456, Severity: 14, State: 16.

2002-02-22 19:59:46.62 Logon Login failed for user 'frontend'. [CLIENT: 10.0.0.75]

I found it is supossed to be a password mismatch:

http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx

but I checked the password is correct.

Any ideas? Thank you in advance.

State: 16

It means the login does not have permissions to log into the target database, i.e. lituania in your case.

This is also indicated by the error msg: --> Cannot open database "lituania" requested by the login. The login failed.

So, please make sure you grant access privilige to "frontend".

|||Been there / done that. Maybe I'm not granting the access priviledge correctly.

What I do is right-clicking over the lituania database within the Microsoft SQL Server Management Studio Express. Then I go to Properties -> Permissions -> Users or roles: frontend -> Explicit permissions for frontend: (and in the Grant column I grant actually everything) -> OK

Still the same problem.

Please help.|||Hi,

navigate through Security > Logins > Properties > User Mapping > Choose the Database > Map the user to the database (you will see that he will get the public role by default)

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||I did that and then checked db_accessadmin (that was unchecked) and leave public checked (anyway I cannot uncheck it). Then I pressed OK and got the message:

Create failed for user 'frontend'. (Microsoft.SqlServer.Express.Smo)
Additional information:
An exception ocurred while executing a Transact-SQL statement or batch, (Microsoft.SqlServer.Express.ConnectionInfo)
User, group or role 'frontend' already exists in the current database. (Microsoft SQL Server, Error: 15023)

Any ideas?|||moving to SQL Security forum. Somebody should be able to help you.|||

I got the same problem. May anyone help me to solve this?

Thanks a lot!

|||

You should check the database permissions catalog for database 'lituania', to verify that the user 'frontend' is actually granted access permissions to the database.

Thanks
Laurentiu

Error: 18456, Severity: 14, State: 16.

I'm getting the same error trying to connect for the first time in SQL Server
2005 from a c#.NET console app. Did you figure it out?
"payyans" wrote:
[vbcol=seagreen]
> The application was able to make connections using the same credentials in
> the initial hours of run. So, I am not sure why permission is denied at a
> later point. Thanks for the response.
> -payyans
> "Russell Fields" wrote:
Not yet.
-payyans
"jt" wrote:
[vbcol=seagreen]
> I'm getting the same error trying to connect for the first time in SQL Server
> 2005 from a c#.NET console app. Did you figure it out?
> "payyans" wrote:

Error: 18456, Severity: 14, State: 16

Hi All,
I am getting the following error in the ERRORLOG File when I am trying
to connect to SQL Server 2005 Express Edition from the command line.
2007-03-23 07:30:05.54 Logon Error: 18456, Severity: 14, State:
16.
2007-03-23 07:30:05.54 Logon Login failed for user 'sa'.
[CLIENT: xx.xx.xx.xx]
I have a fresh install of SQL Server on my local machine, which is
probably the source of my angst, but I am trying to create a database
from scratch through using a batch file that is run from the command
line, the batch file looks like this:
<snip>
SQLCMD -U %USR% -P %PWD% -S %SVR% -d %DBF% -i CreateDatabase.sql
<snip>
The values of %USR% and %PWD% are correct as I frequently log into
Management Studio with the details, %SVR% is "<ComputerName>
\SQLEXPRESS,1433" and %DBF% is <DatabaseName>. The contents of
CreateDatabase.sql when run in Management Studio successfully creates
the database that I require so I know the error doesn't lie there.
The command line error that is showing reads as the following:
Msg 4060, Level 11, State 1, Server <ComputerName>\SQLEXPRESS, Line 1
Cannot open database "<DatabaseName>" requested by the login. The
login failed.
Msg 18456, Level 14, State 1, Server <ComputerName>\SQLEXPRESS, Line 1
Login failed for user 'sa'.
I have a feeling that it is related to 'sa' not having the correct
permissions with regards to logging into or creating a database from
scratch, but I find it odd that I can login as 'sa' in Management
Studio and create the database from there, but when I try it from the
command-line (despite having TCP/IP enabled) it won't let me connect
to create a database.
Is there something I am missing here? I have been banging my head off
of walls for days over this and am unsure of the next steps to take.
If any of this screams "why the hell are you doing this?" then please
let me know as at the moment I am punching in the dark with this
problem, I have searched Usenet, Google Groups, the Web and although I
have found potential solutions to this particular problem I am having,
nothing I have done so far has actually managed to fix the issue.
Related articles I have followed are:
Login failed for user 'x'
http://msdn2.microsoft.com/en-us/library/ms366351.aspx
Change Server Authentication Mode
http://msdn2.microsoft.com/en-us/library/ms188670.aspx
Upgrading MSDE 2000 to SQL Server 2005 Express [Enabling network
protocols section]
http://www.microsoft.com/technet/pr...sqlexpress.mspx
NOTE: I just listed these articles to show what path I am currently
looking at with regards to this problem, but again I stress I have
found nothing yet to get round this problem, and any further articles
or direction would be much appreciated.
Yours Distressingly
AlastairDoes the password have any blank spaces or double quotes ?
Jens K. Suessmeyer.
http://www.sqlserver2005.de
--
"Alastair" <alastair_anderson@.hotmail.com> wrote in message
news:1174642161.471601.110030@.y80g2000hsf.googlegroups.com...
> Hi All,
> I am getting the following error in the ERRORLOG File when I am trying
> to connect to SQL Server 2005 Express Edition from the command line.
> 2007-03-23 07:30:05.54 Logon Error: 18456, Severity: 14, State:
> 16.
> 2007-03-23 07:30:05.54 Logon Login failed for user 'sa'.
> [CLIENT: xx.xx.xx.xx]
> I have a fresh install of SQL Server on my local machine, which is
> probably the source of my angst, but I am trying to create a database
> from scratch through using a batch file that is run from the command
> line, the batch file looks like this:
> <snip>
> SQLCMD -U %USR% -P %PWD% -S %SVR% -d %DBF% -i CreateDatabase.sql
> <snip>
> The values of %USR% and %PWD% are correct as I frequently log into
> Management Studio with the details, %SVR% is "<ComputerName>
> \SQLEXPRESS,1433" and %DBF% is <DatabaseName>. The contents of
> CreateDatabase.sql when run in Management Studio successfully creates
> the database that I require so I know the error doesn't lie there.
> The command line error that is showing reads as the following:
> Msg 4060, Level 11, State 1, Server <ComputerName>\SQLEXPRESS, Line 1
> Cannot open database "<DatabaseName>" requested by the login. The
> login failed.
> Msg 18456, Level 14, State 1, Server <ComputerName>\SQLEXPRESS, Line 1
> Login failed for user 'sa'.
> I have a feeling that it is related to 'sa' not having the correct
> permissions with regards to logging into or creating a database from
> scratch, but I find it odd that I can login as 'sa' in Management
> Studio and create the database from there, but when I try it from the
> command-line (despite having TCP/IP enabled) it won't let me connect
> to create a database.
> Is there something I am missing here? I have been banging my head off
> of walls for days over this and am unsure of the next steps to take.
> If any of this screams "why the hell are you doing this?" then please
> let me know as at the moment I am punching in the dark with this
> problem, I have searched Usenet, Google Groups, the Web and although I
> have found potential solutions to this particular problem I am having,
> nothing I have done so far has actually managed to fix the issue.
> Related articles I have followed are:
> Login failed for user 'x'
> http://msdn2.microsoft.com/en-us/library/ms366351.aspx
> Change Server Authentication Mode
> http://msdn2.microsoft.com/en-us/library/ms188670.aspx
> Upgrading MSDE 2000 to SQL Server 2005 Express [Enabling network
> protocols section]
> http://www.microsoft.com/technet/pr...sqlexpress.mspx
> NOTE: I just listed these articles to show what path I am currently
> looking at with regards to this problem, but again I stress I have
> found nothing yet to get round this problem, and any further articles
> or direction would be much appreciated.
> Yours Distressingly
> Alastair
>|||On 23 Mar, 13:00, "Jens K. Suessmeyer" <J...@.NoSpamhere-
sqlserver2005.de> wrote:
> Does the password have any blank spaces or double quotes ?
> Jens K. Suessmeyer.
> --http://www.sqlserver2005.de
> --
> "Alastair" <alastair_ander...@.hotmail.com> wrote in message
> news:1174642161.471601.110030@.y80g2000hsf.googlegroups.com...
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> - Show quoted text -
The only double quotes that it contains are those that surround the
password in the .bat file.
Should these be single quotes?|||Normally this should work, did you try conencting with the same syntax that
you are using in the batch file via an interactive commandprompt ? Did you
try to leave out the quotes ?
Jens K. Suessmeyer.
http://www.sqlserver2005.de
--
"Alastair" <alastair_anderson@.hotmail.com> wrote in message
news:1174655306.297982.325260@.b75g2000hsg.googlegroups.com...
> On 23 Mar, 13:00, "Jens K. Suessmeyer" <J...@.NoSpamhere-
> sqlserver2005.de> wrote:
> The only double quotes that it contains are those that surround the
> password in the .bat file.
> Should these be single quotes?
>|||On 23 Mar, 21:26, "Jens K. Suessmeyer" <J...@.NoSpamhere-
sqlserver2005.de> wrote:
> Normally this should work, did you try conencting with the same syntax tha
t
> you are using in the batch file via an interactive commandprompt ? Did you
> try to leave out the quotes ?
> Jens K. Suessmeyer.
> --http://www.sqlserver2005.de
> --
> "Alastair" <alastair_ander...@.hotmail.com> wrote in message
> news:1174655306.297982.325260@.b75g2000hsg.googlegroups.com...
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> - Show quoted text -
Hi Jens,
Thanks for the input on this it is very much appreciated,
I tried running the batch file without quotations around the strings
and I still get the same error, I also tried single quotes, but the
command-line processor was interpreting them as part of the strings.
I took your advice and tried running it straight from the command-line
without using the .bat file, and still the same error came screaming
back at me.
Alastair|||On 23 Mar, 21:26, "Jens K. Suessmeyer" <J...@.NoSpamhere-
sqlserver2005.de> wrote:
> Normally this should work, did you try conencting with the same syntax tha
t
> you are using in the batch file via an interactive commandprompt ? Did you
> try to leave out the quotes ?
> Jens K. Suessmeyer.
> --http://www.sqlserver2005.de
> --
> "Alastair" <alastair_ander...@.hotmail.com> wrote in message
> news:1174655306.297982.325260@.b75g2000hsg.googlegroups.com...
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> - Show quoted text -
I've done some further hunting around for solutions, could it
potentially be related to "sa" not having any permissions in the
SYS.DATABASE_PERMISSIONS table?|||No, sa has by default access to everything, including the internal data.
Jens K. Suessmeyer.
http://www.sqlserver2005.de
--
"Alastair" <alastair_anderson@.hotmail.com> wrote in message
news:1174779869.212689.303860@.o5g2000hsb.googlegroups.com...
> On 23 Mar, 21:26, "Jens K. Suessmeyer" <J...@.NoSpamhere-
> sqlserver2005.de> wrote:
> I've done some further hunting around for solutions, could it
> potentially be related to "sa" not having any permissions in the
> SYS.DATABASE_PERMISSIONS table?
>

Error: 18456, Severity: 14, State: 11 Valid login but server access failure

Hi

I am new to SQL server and I have been trying hard to make a client computer to remote connect to a SQL express database on host computer

I have a VB6 application that can connect to SQL server database LOCALLY without problem:

Connection String is:

my_connection.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=MyMushroom;Data Source=LAPTOP\SQLEXPRESS"

I have followed instruction on enabling remote connection function from this blog:

http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx

I then try to run the same app from the client computer, it gives me:

Login failed for user 'LAPTOP\Guest'.

After looking up the web for solution, I found that I can test the connection from the HOST computer in this way:

C:\Documents and Settings\kit>sqlcmd -E -S laptop\sqlexpress
1>
2>

The test is successful

Now I run the same command on the CLIENT computer

C:\Documents and Settings\Kit>sqlcmd -E -S laptop\sqlexpress
Msg 18456, Level 14, State 1, Server LAPTOP\SQLEXPRESS, Line 1
Login failed for user 'LAPTOP\Guest'.

Now I can sure that from the client computer it cannot make a connection to it, then I look at the errorLog from my host computer

2006-08-13 21:41:00.34 Logon Error: 18456, Severity: 14, State: 11.
2006-08-13 21:41:00.34 Logon Login failed for user 'LAPTOP\Guest'. [CLIENT: 192.168.0.5]
2006-08-13 21:45:10.64 Logon Error: 18456, Severity: 14, State: 11.
2006-08-13 21:45:10.64 Logon Login failed for user 'LAPTOP\Guest'. [CLIENT: 192.168.0.5]
2006-08-13 21:48:41.80 Logon Error: 18456, Severity: 14, State: 11.
2006-08-13 21:48:41.80 Logon Login failed for user 'LAPTOP\Guest'. [CLIENT: 192.168.0.5]

Now I know it is actually Error: 18456, Severity: 14, State: 11.

From this site : http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx

11 and 12

Valid login but server access failure

It tells the connection string and SQL Express seem to be set up properly but the server access failed the remote connection

I have previously had SQL Server 2000 installed. I uninstalled SQL 2000 before I install SQL express but somehow the SQL Server Service Manager is still running at startup, and C:\Program Files\Microsoft SQL Server\80 and its files are still exist after uninstallation..... Could this be a problem?

The Knowledge base suggestion on "enabling remote connection" is very simple and I do not understand why it is so difficult to me just to make a remote connection test work..... please, I need your help.

If you want to use Windows Authentication you have to disable the "Simple File and printer sharing" at the "server" (even if its only WIndows XP). With this option enabled, it normally simplifies the logon process as the requestor does not have to give a user name and a password, because he will be logged on with the Guest user.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||I did try to disable the file sharing, and also have firewall disabled. But it still gives me the same error..... |||

OK, did you disable that on the "server" (Whereever SQL Server is running on) ?

-Jens.

|||

Yes, to make sure file sharing is disabled , I unlick the Simple File Sharing from Folder Option on both computers.

Both computer have file sharing disabled

filewall disabled

But I am still getting the same error.

Anything to do with MSDE 2000 instance? I have uninstalled MSDE2000 before I install SQL expresss.

What is wrong still?

|||

By the way, I restarted both computer and still got the same error on the client computer while the hosting computer is connecting to the KIT\SQLExpress alright :

C:\Documents and Settings\Kit>sqlcmd -E -S kit\sqlexpress
1>
2>
3>
4>
5>

Here is the current setting of my SQLexpress instance

SQL Server Config. Manager
Protoal: Shared Memory, TCP/IP enabled (Name Pipes and VIA disabled)
SQL server (SQLExpress) and SQL server Browser are running , startmode: automatic
For SQL Server Browser: Log on as : Bulit-in account: Network Service
For SQL Server (SQLExpress): Log on as : Bulit-in account: Network Service
Under Service - General -
Host Name: KIT
Name: SQL Server (SQLExpress)

SQL Native Config. - Client Protocols - Shard Memory 1, TCP/IP 2

SQL Server Surface Area Config.
Service Name: MSSQL$SQLEXPRESS
Display Name: SQL Server (SQLEXPRESS)
Remote COnnection: Local and Remote connection clicked - Using TCP/IP Only clicked

The client computer do not have any SQL express installed, could that be the reason?

Frankly, on the server computer , it can connect to the database on TCP/IP using SQL Management Studio

Here I attached the screen shots

http://www.megaupload.com/?d=JWN349QL

|||

I have a few questions about your setup:

- on the client machine, what account is your application running under?
- when you tried connecting to SQL Express locally, using sqlcmd, what was the account you actually connected as? (you can execute "select suser_name()" to find this out)

Thanks
Laurentiu

|||

Client is running Win XP Professional SP2

Server is running Win XP pro SP2

Client machine is logged in as Admin , without password (so it goes straight into the OS when you start up the machine and bypass the log in screen)

Server machine is also logged in as Admin, with passowrd (log-in: Kit, password: Kit) , TweakUI is setup to log in automatically using the log-in/password pair.

- when you tried connecting to SQL Express locally, using sqlcmd, what was the account you actually connected as? (you can execute "select suser_name()" to find this out) :

C:\Documents and Settings\Kit>sqlcmd -E -S kit\sqlexpress
1> select suser_name()
2> go

--
KIT\Kit

(1 rows affected)
1>

Hope this will give you idea of what has gone wrong with my SQL express setting

Thank you for your response.

|||

On the Server Computer , under Control Panel -> User Accounts , there are 3 accounts: Kit (myself), SQLDebugger and Guest

Guest account is not password protected and is set to off. (I've tried to turn this account on and off but the client computer still give me the same error)

I really havae no idea what I have gone it wrong...

|||

I just realize what you meant by "on the client machine, what account is your application running under?"

It is running under Network Service

|||

Locally, you connect as Kit, which seems to have server access. Remotely, you appear to execute as Network Service and when you get on the server machine, you are actually running as Guest, which does not have server access.

If you execute

CREATE LOGIN [Laptop\Guest] FROM WINDOWS

then you will grant server access to the Guest account.

But if you want your application to connect as Kit, you should run it as Kit or it should internally impersonate Kit before connecting to the server.

Thanks
Laurentiu

|||

To Laurentiu and Jens:

Thank you for your great help and now the client can connect to the server SQL express. I have been myself studying the SQL server and exploring how SQL server work. This SQL express is very interesting and I have a lot more to learn about this "toy".

I am very appreciated to your helps.

Kit

error: 0 - No process is on the other end of the pipe

I can use SQL Server Management Studio Express to connect to my local database SQL 2005 database on bknji\sqlexpress.

I am also able to connect to the database from Visual Studio, and this is where I copied the following connection string to be used in my C# code

string myConnectString = "Data Source=BKFNJI\\SQLEXPRESS;" +

"Initial Catalog=cmiCompatibilityDataBase" +

"Integrated Security=True;Pooling=False";

// specify SQL Server Specific Connection string

SqlConnection cmiDBCompConnection = new SqlConnection(myConnectString);

cmiDBCompConnection.Open();

when I attempt to run the apps, I get the

"System.Data.SqlClient.SqlException was unhandled
Message="A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)".....

any idea what I am doing wrong, given that the connection string works using other means? I am using Windows authentication.

To add, the error in my log shows:

2007-03-17 21:10:55.82 Logon Login failed for user ''. The user is not associated with a trusted SQL Server connection. [CLIENT: <local machine>]

Thanks,

Klaus

Seems although the server is expecting Windows Authentication, either no username was passed to the server internally or you are using a different connectionstring than the one posted above. Could you descrive your environment ? Are you in a domain, is the machine you are connecting from the same machine as the development machine ?

Jens K. Suessmeyer.

http://www.sqlserver2005.de

Error. My aspx file cant access server to connect to database

Hi,

I am writing my first aspx file to connect to a standalone SQL Server which is separated from the IIS webserver. The code is

<HTML>
<HEAD>
<TITLE>Store Locator</TITLE>
<script runat="server">
Sub Page_Load(ByVal Sender as Object, ByVal E as EventArgs)
if Not IsPostBack Then
Dim DBConn as OleDbConnection
Dim DBCommand As OleDbDataAdapter
Dim DSPageData as New DataSet
DBConn = New OleDbConnection("Provider=sqloledb;" _
& "server=dailyplanet;" _
& "Initial Catalog=JAVSTORE;" _
& "User Id=javtrader;" _
& "Password=rage123;")
DBCommand = New OleDbDataAdapter _
("Select * " _
& "From JAVInventory " _
& "Where ID > ((Select COUNT(ID) " _
& "From JAVInventory ) - 100)" _
& "Order By ID DESC", DBConn)
DBCommand.Fill(DSPageData, _
"RecentJAVs")
' ddlZipCode.DataSource = _
' DSPageData.Tables("RecentJAVs").DefaultView
' ddlZipCode.DataBind()
End If
End Sub

I used Visual .Net and Web Matrix and was able to connect to the sql server with the Data Connection to view the tables. However, when I use IIS or the Visual .Net debugger to run the aspx file, it get the following error.. please help..

Server Error in '/javtrade' Application.
------------------------

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.OleDb.OleDbException: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

Source Error:

Line 21: & "From JAVInventory ) - 100)" _
Line 22: & "Order By ID DESC", DBConn)
Line 23: DBCommand.Fill(DSPageData, _
Line 24: "RecentJAVs")
Line 25: ' ddlZipCode.DataSource = _

Source File: c:\inetpub\wwwroot\javtrade\management.aspx Line: 23

Stack Trace:

[OleDbException (0x80004005): [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.]
System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr)
System.Data.OleDb.OleDbConnection.InitializeProvider()
System.Data.OleDb.OleDbConnection.Open()
System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState) +44
System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +304
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +77
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +36
ASP.management_aspx.Page_Load(Object Sender, EventArgs E) in c:\inetpub\wwwroot\javtrade\management.aspx:23
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731FYI, when using sql server it is better to use the sql namespace over the oledb. I assume you have a connection string in your web.config file. This can be formed in two ways, one using a trusted connection, or the other being uid=; and pwd=; the login and password for sql respectively. Either version of the connection string must include the server name, which is localhost, 127.0.0.1 if on the localmachine or the actual name or ip of the server.

Error with SQL Server 2K5 "Cannot connect... Instance failure"

I am getting the following error when trying to connect to SQL Server
2005 Express through Microsoft SQL Server Management Studio Express
CTP.
"Cannot connect to SERVER\SQLEXPRESS
Additional Information:
Instance Failure. (System.Data)"
One thing I noticed, the "SQL Server (SQLEXPRESS) service is set to
start automatically yet, it wasn't started. I tried to start it, but
kept receiving a message that the service was started and then stop for
a rerason along the lines "if a service isn't need, it stops itself".
So...
I stopped the following services and restarted them:
MSSQL$SHAREPOINT
MSSQLSERVER
SQL Server Browser
and it finally let me start "SQL Server (SQLEXPRESS)" !!
After stopping and starting the 4 services above, it let me in again.
This is the 3rd time this has happened to me. Anyone have any ideas?
Hi
This sounds like you are using a user instance?
This may help
http://msdn.microsoft.com/library/de...xpuserinst.asp
What is the exact error number and message in the SQL Server log?
John
"ATJaguarX" wrote:

> I am getting the following error when trying to connect to SQL Server
> 2005 Express through Microsoft SQL Server Management Studio Express
> CTP.
> "Cannot connect to SERVER\SQLEXPRESS
>
> Additional Information:
> Instance Failure. (System.Data)"
>
> One thing I noticed, the "SQL Server (SQLEXPRESS) service is set to
> start automatically yet, it wasn't started. I tried to start it, but
> kept receiving a message that the service was started and then stop for
> a rerason along the lines "if a service isn't need, it stops itself".
> So...
>
> I stopped the following services and restarted them:
>
> MSSQL$SHAREPOINT
> MSSQLSERVER
> SQL Server Browser
>
> and it finally let me start "SQL Server (SQLEXPRESS)" !!
>
> After stopping and starting the 4 services above, it let me in again.
> This is the 3rd time this has happened to me. Anyone have any ideas?
>
|||I am not sure if I am running a user instance. I have yet to design an
application to hit my database, I have only been logging into the
management tool.
My error logs are all empty. Is there something I need to do to turn
these on?
|||Hi
If you had a user instance the database would only be attached when it was
connected to.
You can use SSEUtil to connect to the instance.
John
"ATJaguarX" wrote:

> I am not sure if I am running a user instance. I have yet to design an
> application to hit my database, I have only been logging into the
> management tool.
> My error logs are all empty. Is there something I need to do to turn
> these on?
>

Error with SQL Server 2K5 "Cannot connect... Instance failure"

I am getting the following error when trying to connect to SQL Server
2005 Express through Microsoft SQL Server Management Studio Express
CTP.
"Cannot connect to SERVER\SQLEXPRESS
Additional Information:
Instance Failure. (System.Data)"
One thing I noticed, the "SQL Server (SQLEXPRESS) service is set to
start automatically yet, it wasn't started. I tried to start it, but
kept receiving a message that the service was started and then stop for
a rerason along the lines "if a service isn't need, it stops itself".
So...
I stopped the following services and restarted them:
MSSQL$SHAREPOINT
MSSQLSERVER
SQL Server Browser
and it finally let me start "SQL Server (SQLEXPRESS)" !!
After stopping and starting the 4 services above, it let me in again.
This is the 3rd time this has happened to me. Anyone have any ideas?Hi
This sounds like you are using a user instance?
This may help
http://msdn.microsoft.com/library/d...>
userinst.asp
What is the exact error number and message in the SQL Server log?
John
"ATJaguarX" wrote:

> I am getting the following error when trying to connect to SQL Server
> 2005 Express through Microsoft SQL Server Management Studio Express
> CTP.
> "Cannot connect to SERVER\SQLEXPRESS
>
> Additional Information:
> Instance Failure. (System.Data)"
>
> One thing I noticed, the "SQL Server (SQLEXPRESS) service is set to
> start automatically yet, it wasn't started. I tried to start it, but
> kept receiving a message that the service was started and then stop for
> a rerason along the lines "if a service isn't need, it stops itself".
> So...
>
> I stopped the following services and restarted them:
>
> MSSQL$SHAREPOINT
> MSSQLSERVER
> SQL Server Browser
>
> and it finally let me start "SQL Server (SQLEXPRESS)" !!
>
> After stopping and starting the 4 services above, it let me in again.
> This is the 3rd time this has happened to me. Anyone have any ideas?
>|||I am not sure if I am running a user instance. I have yet to design an
application to hit my database, I have only been logging into the
management tool.
My error logs are all empty. Is there something I need to do to turn
these on?|||Hi
If you had a user instance the database would only be attached when it was
connected to.
You can use SSEUtil to connect to the instance.
John
"ATJaguarX" wrote:

> I am not sure if I am running a user instance. I have yet to design an
> application to hit my database, I have only been logging into the
> management tool.
> My error logs are all empty. Is there something I need to do to turn
> these on?
>

Error with SQL Server 2K5 "Cannot connect... Instance failure"

I am getting the following error when trying to connect to SQL Server
2005 Express through Microsoft SQL Server Management Studio Express
CTP.
"Cannot connect to SERVER\SQLEXPRESS
Additional Information:
Instance Failure. (System.Data)"
One thing I noticed, the "SQL Server (SQLEXPRESS) service is set to
start automatically yet, it wasn't started. I tried to start it, but
kept receiving a message that the service was started and then stop for
a rerason along the lines "if a service isn't need, it stops itself".
So...
I stopped the following services and restarted them:
MSSQL$SHAREPOINT
MSSQLSERVER
SQL Server Browser
and it finally let me start "SQL Server (SQLEXPRESS)" !!
After stopping and starting the 4 services above, it let me in again.
This is the 3rd time this has happened to me. Anyone have any ideas?Hi
This sounds like you are using a user instance?
This may help
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsse/html/sqlexpuserinst.asp
What is the exact error number and message in the SQL Server log?
John
"ATJaguarX" wrote:
> I am getting the following error when trying to connect to SQL Server
> 2005 Express through Microsoft SQL Server Management Studio Express
> CTP.
> "Cannot connect to SERVER\SQLEXPRESS
>
> Additional Information:
> Instance Failure. (System.Data)"
>
> One thing I noticed, the "SQL Server (SQLEXPRESS) service is set to
> start automatically yet, it wasn't started. I tried to start it, but
> kept receiving a message that the service was started and then stop for
> a rerason along the lines "if a service isn't need, it stops itself".
> So...
>
> I stopped the following services and restarted them:
>
> MSSQL$SHAREPOINT
> MSSQLSERVER
> SQL Server Browser
>
> and it finally let me start "SQL Server (SQLEXPRESS)" !!
>
> After stopping and starting the 4 services above, it let me in again.
> This is the 3rd time this has happened to me. Anyone have any ideas?
>|||I am not sure if I am running a user instance. I have yet to design an
application to hit my database, I have only been logging into the
management tool.
My error logs are all empty. Is there something I need to do to turn
these on?|||Hi
If you had a user instance the database would only be attached when it was
connected to.
You can use SSEUtil to connect to the instance.
John
"ATJaguarX" wrote:
> I am not sure if I am running a user instance. I have yet to design an
> application to hit my database, I have only been logging into the
> management tool.
> My error logs are all empty. Is there something I need to do to turn
> these on?
>

Error while verifying database on crystal report

I am using crystal report 7 to connect with stored proc on a sybase 11 server. I am getting the following error when tried to refresh the database.
ODBC error:[intersolv][odbc sql server driver]optional feature not implemented. Error in parameter 1.
How can this be resolved? :confused: Stored proc is fine and it runs perfectly when executed. But when refreshed thru the crystal report, I get the error. :( The changes made on the database are not reflected because of this error. :oFor SQL Server database, an error file is created at the location

C:\WINDOWS\Crystal\SQLSvr.err

This file gives the reason for the errors occuring in the report. Check if such a file is created for Sybase. Prob this would help you.

Rashmi

Error while trying to connect to another SQL Server Express machine

The error states:

Additional Information:
An error has occured while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that unthe default settings SQL Server does not allow remote connections.

How do I correct this issue?

Thanks,

Steve C.

By default, SQL Server 2005 Express Edition disables network access / remote connections. This is for security purposes. We want this enabled explicitly should someone have a need for it. Here is a KB article that talks about ways to enable remote connections http://support.microsoft.com/default.aspx?scid=kb%3bEN-US%3b914277

Thank You

Ajay

Error while i register from Enterprise manager

Hello,
Although i have a login account in the SQL server and also i am able
to connect via my application, but somehow when i try to register the
server from the enterprise manager i get the following message
SQL Server registration failed because of the connection failure
displayed below. Do you wish to Register anyway ?
[SQL-DMO]Code execution exception: exception_access_violation"
I am stuck up..
Can anyone suggest me a solution for this problem.
Kind Regards,
Amit KumarThere is an exception logged in the SQL Server errorlog. There probably
will not be much there to help you resolve the problem but Microsoft
support can probably decipher it.
Rand
This posting is provided "as is" with no warranties and confers no rights.

Error while connection

Hi I want to connect with Magic 9.4 to the northwind table.

I get always this error:

Error during the registration user SA. A cause: No familiar SQL server
connection assigned.

How can I create a trusted server connection ?

Thanks.

Volker"Volker Pieper - Rayman" <rayman@.idepro.d> wrote in message news:<bvmbk0$b5d$1@.online.de>...
> Hi I want to connect with Magic 9.4 to the northwind table.
> I get always this error:
> Error during the registration user SA. A cause: No familiar SQL server
> connection assigned.
> How can I create a trusted server connection ?
> Thanks.
> Volker

To make a trusted connection (and assuming you're using SQL 2000),
then you need to grant server access to the Windows account you're
using to connect, as well as the necessary database access. You can
use Enterprise Manager, or see sp_grantlogin and sp_grantdbaccess in
Books Online.

After that, you have to tell your client application to use a trusted
connection instead of a SQL login/password. That depends on which
client library you're using, so you would need to check your Magic
documentation on that.

Simon