Error: Generating Instances in SQL Server is disabled...

Use sp_configure 'user instances enabled' to generate user instances.

I get the above error when I attempt to add an SQL Database item into my VS (C#) project. I do not understand what needs to be done to correct the problem.

Any help is appreciated.

Thank You,

Klaus

From SQL Server 2005 Books Onlinetopic:

user instances enabled Option

http://msdn2.microsoft.com/en-us/library/ms187513.aspx

The user instance enabled option that you can access through sp_configure is not supported in Microsoft SQL Server 2005. This option works only with SQL Server 2005 Express Edition (SQL Server Express).

For more information about how user instances work, see User Instances for Non-Administrators.

User Instances for Non-Administrators

http://msdn2.microsoft.com/en-us/library/ms143684.aspx

Error: Failed to generate a user instance...

Hello,

When trying to add a new SQL database to a VS 2005 project I get this 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. [CLIENT: <local machine>]

Any ideas what is causing this error and how to fix it?

Thanks

Tom

Hi Tom,

This question has been discussed several times in this forum, you should do a search and read other discussions to see if they address your issue.

The first step in troubleshooting this is to look at the User Instance error log located at C:\Documents and Settings\<user>\Local Settings\Application Data\Microsoft\Microsoft SQL Server Data\<main instance name> (The default instance name is SQLEXPRESS) and see if it give any clues to the cause of the error.

Regards,

Mike Wachal
SQL Express team

-
Please mark your thread as Answered when you get your solution.

Error: Email Subscription to Report (Sharepoint Integrated Mode) Options

I encounter this error when user try to subscribe using email delivery
to one of the report. I have configured the Reporting Services to use
Sharepoint integrated mode. This user is a regular user that has read
access to the report item.

Below is the message detail:

A subscription delivery error has occurred. (rsDeliveryError)
A subscription delivery error has occurred. (rsDeliveryError)
One of the extension parameters is not valid for the following reason:
The account you are using does not have administrator privileges. A
subscription cannot be created for [emailaddress].
(rsInvalidExtensionParameter)

Is it true that user needs to have administrator privilege in order to
subscribe for report? I don't think so, right?

Regards,
Gunady Ng

Hi Gunady,

Non-admin users can only send a report to an email address that is specified in the SharePoint user profile for that user. Can you check the "TO" field and ensure that the email address is that of the user as seen in the SharePoint user profile?

Thanks,

Sharmila

|||

Thank you for the answer. Is this restriction apply to cc or bcc as well?

Regards,

Gunady Ng

|||

Yes, it applies to all.

Thanks,
Sharmila

|||

is there a way around this?

Is there a way to setup on per-report basis?

I'm using reporting services within sharepoint as a content delivery solution, I need teh users to be able ost chedule reports and have them delivered by email to thair sharpoint drop box and/or to their customers staright from teh subscripton interface

I'm able to do this as admin but I need teh users to be able to do the same

I tried looking in the rsreportsever.config but can not figure out how to do this, I set <sendemailtouseralias>False but still nothing,

I also dont have the otion for CC: or BCC: when I'm loged in with nonadministrative account.

There must be an option for this but I'm not finding it in any documentation

I'm running Reporting Services SP2 in WSS3 integrated mode

Please advice and help...

Thanks

Nik

Error: Email Subscription to Report (Sharepoint Integrated Mode) Options

I encounter this error when user try to subscribe using email delivery
to one of the report. I have configured the Reporting Services to use
Sharepoint integrated mode. This user is a regular user that has read
access to the report item.

Below is the message detail:

A subscription delivery error has occurred. (rsDeliveryError)
A subscription delivery error has occurred. (rsDeliveryError)
One of the extension parameters is not valid for the following reason:
The account you are using does not have administrator privileges. A
subscription cannot be created for [emailaddress].
(rsInvalidExtensionParameter)

Is it true that user needs to have administrator privilege in order to
subscribe for report? I don't think so, right?

Regards,
Gunady Ng

Hi Gunady,

Non-admin users can only send a report to an email address that is specified in the SharePoint user profile for that user. Can you check the "TO" field and ensure that the email address is that of the user as seen in the SharePoint user profile?

Thanks,

Sharmila

|||

Thank you for the answer. Is this restriction apply to cc or bcc as well?

Regards,

Gunady Ng

|||

Yes, it applies to all.

Thanks,
Sharmila

|||

is there a way around this?

Is there a way to setup on per-report basis?

I'm using reporting services within sharepoint as a content delivery solution, I need teh users to be able ost chedule reports and have them delivered by email to thair sharpoint drop box and/or to their customers staright from teh subscripton interface

I'm able to do this as admin but I need teh users to be able to do the same

I tried looking in the rsreportsever.config but can not figure out how to do this, I set <sendemailtouseralias>False but still nothing,

I also dont have the otion for CC: or BCC: when I'm loged in with nonadministrative account.

There must be an option for this but I'm not finding it in any documentation

I'm running Reporting Services SP2 in WSS3 integrated mode

Please advice and help...

Thanks

Nik

Error: Email Subscription to Report (Sharepoint Integrated Mode) Options

I encounter this error when user try to subscribe using email delivery
to one of the report. I have configured the Reporting Services to use
Sharepoint integrated mode. This user is a regular user that has read
access to the report item.

Below is the message detail:

A subscription delivery error has occurred. (rsDeliveryError)
A subscription delivery error has occurred. (rsDeliveryError)
One of the extension parameters is not valid for the following reason:
The account you are using does not have administrator privileges. A
subscription cannot be created for [emailaddress].
(rsInvalidExtensionParameter)

Is it true that user needs to have administrator privilege in order to
subscribe for report? I don't think so, right?

Regards,
Gunady Ng

Hi Gunady,

Non-admin users can only send a report to an email address that is specified in the SharePoint user profile for that user. Can you check the "TO" field and ensure that the email address is that of the user as seen in the SharePoint user profile?

Thanks,

Sharmila

|||

Thank you for the answer. Is this restriction apply to cc or bcc as well?

Regards,

Gunady Ng

|||

Yes, it applies to all.

Thanks,
Sharmila

|||

is there a way around this?

Is there a way to setup on per-report basis?

I'm using reporting services within sharepoint as a content delivery solution, I need teh users to be able ost chedule reports and have them delivered by email to thair sharpoint drop box and/or to their customers staright from teh subscripton interface

I'm able to do this as admin but I need teh users to be able to do the same

I tried looking in the rsreportsever.config but can not figure out how to do this, I set <sendemailtouseralias>False but still nothing,

I also dont have the otion for CC: or BCC: when I'm loged in with nonadministrative account.

There must be an option for this but I'm not finding it in any documentation

I'm running Reporting Services SP2 in WSS3 integrated mode

Please advice and help...

Thanks

Nik

Error: Cannot impersonate user for data source

An error has occurred during report processing. (rsProcessingAborted)

Cannot impersonate user for data source 'DataSource1'. (rsErrorImpersonatingUser)

Logon failed. (rsLogonFailed)

For more information about this error navigate to the report server on the local server machine, or enable remote errors

Any help would be greatly appreciated. Thank you.

Can you enable remote errors so we can see the detailed error message:

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

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 am getting the error

Error: 18456, Severity: 14, State: 16.
Login failed for user 'PRI\sqlservice'. [CLIENT: 172.16.9.2]

in the log repeated every 15 seconds or so. I am logged into the server as pri\sqlservice, I have started the sql server and sql server agent with pri\sqlservice and I can access databases and tables inside the Server Management studio. I have set up the login pri\sqlservice and given it dbo owner access to all databases.

I am in the process of upgrading from 2000 to 2005. I have installed a new sql server 2005, restored backups of databases from 2000. I have also converted all packages and uploaded those to the new server (although they all point to the 2000 server). I have imported the jobs, but all but one are disabled and the one that is enabled ran okay when I ran it manually.

I have researched and researched this issue, and none seem to apply to my specific issue.

This is an extract of my errorlog:

2006-12-20 16:23:16.95 Server Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)
Oct 14 2005 00:33:37
Copyright (c) 1988-2005 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

2006-12-20 16:23:16.98 Server (c) 2005 Microsoft Corporation.
2006-12-20 16:23:16.98 Server All rights reserved.
2006-12-20 16:23:16.98 Server Server process ID is 1780.
2006-12-20 16:23:16.98 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2006-12-20 16:23:16.98 Server This instance of SQL Server last reported using a process ID of 4532 at 12/20/2006 4:23:52 PM (local) 12/20/2006 9:23:52 PM (UTC). This is an informational message only; no user action is required.
2006-12-20 16:23:16.98 Server Registry startup parameters:
2006-12-20 16:23:17.00 Server -d C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2006-12-20 16:23:17.00 Server -e C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2006-12-20 16:23:17.00 Server -l C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2006-12-20 16:23:17.23 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2006-12-20 16:23:17.23 Server Detected 2 CPUs. This is an informational message; no user action is required.
2006-12-20 16:23:17.93 Server Set AWE Enabled to 1 in the configuration parameters to allow use of more memory.
2006-12-20 16:23:19.65 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2006-12-20 16:23:22.07 Server Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2006-12-20 16:23:23.21 Server Attempting to recover in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2006-12-20 16:23:23.48 Server Database Mirroring Transport is disabled in the endpoint configuration.
2006-12-20 16:23:23.79 spid5s Starting up database 'master'.
2006-12-20 16:23:25.01 spid5s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2006-12-20 16:23:26.17 spid5s SQL Trace ID 1 was started by login "sa".
2006-12-20 16:23:26.37 spid5s Starting up database 'mssqlsystemresource'.
2006-12-20 16:23:27.93 spid9s Starting up database 'model'.
2006-12-20 16:23:27.95 spid5s Server name is 'KSDBT01'. This is an informational message only. No user action is required.
2006-12-20 16:23:29.06 spid9s Clearing tempdb database.
2006-12-20 16:23:29.54 Server A self-generated certificate was successfully loaded for encryption.
2006-12-20 16:23:29.62 Server Server is listening on [ 'any' <ipv4> 1433].
2006-12-20 16:23:29.62 Server Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].
2006-12-20 16:23:29.62 Server Server local connection provider is ready to accept connection on [ \\.\pipe\sql\query ].
2006-12-20 16:23:29.64 Server Server is listening on [ 127.0.0.1 <ipv4> 1434].
2006-12-20 16:23:29.64 Server Dedicated admin connection support was established for listening locally on port 1434.
2006-12-20 16:23:29.68 Server SQL Server is now ready for client connections. This is an informational message; no user action is required.
2006-12-20 16:23:32.56 spid9s Starting up database 'tempdb'.
2006-12-20 16:23:32.67 spid13s Starting up database 'msdb'.
2006-12-20 16:23:32.67 spid12s Starting up database 'test'.
2006-12-20 16:23:32.67 spid14s Starting up database 'bravoAztecnology'.
2006-12-20 16:23:32.67 spid15s Starting up database 'bravoKNE'.
2006-12-20 16:23:32.67 spid16s Starting up database 'bravoKNS'.
2006-12-20 16:23:32.67 spid17s Starting up database 'bravoKNSBelgium'.
2006-12-20 16:23:32.68 spid18s Starting up database 'bravoKNSCanada'.
2006-12-20 16:23:32.68 spid19s Starting up database 'bravoKNSEngland'.
2006-12-20 16:23:34.79 spid20s The Service Broker protocol transport is disabled or not configured.
2006-12-20 16:23:34.81 spid20s The Database Mirroring protocol transport is disabled or not configured.
2006-12-20 16:23:35.01 spid12s Starting up database 'bravoKNSKennedy'.
2006-12-20 16:23:35.20 spid17s Starting up database 'bravoKNSSuperior'.
2006-12-20 16:23:35.35 spid13s Starting up database 'bravoKNSSuperiorSS'.
2006-12-20 16:23:35.48 spid19s Starting up database 'stamp'.
2006-12-20 16:23:35.83 spid20s Service Broker manager has started.
2006-12-20 16:23:38.59 spid14s Starting up database 'KNSSpecial'.
2006-12-20 16:23:39.31 spid18s Starting up database 'knsRPCS'.
2006-12-20 16:23:39.39 spid14s Analysis of database 'KNSSpecial' (16) is 100% complete (approximately 0 seconds remain). This is an informational message only. No user action is required.
2006-12-20 16:23:43.03 spid5s Recovery of any in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC) has completed. This is an informational message only. No user action is required.
2006-12-20 16:23:43.03 spid5s Recovery is complete. This is an informational message only. No user action is required.
2006-12-20 16:23:50.95 spid51 Using 'xpsqlbot.dll' version '2005.90.1399' to execute extended stored procedure 'xp_qv'. This is an informational message only; no user action is required.
2006-12-20 16:23:55.85 spid51 Using 'xpstar90.dll' version '2005.90.1399' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.
2006-12-20 16:23:57.10 spid51 Using 'xplog70.dll' version '2005.90.1399' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required.
2006-12-20 16:24:00.02 Logon Error: 18456, Severity: 14, State: 16.
2006-12-20 16:24:00.02 Logon Login failed for user 'PRI\sqlservice'. [CLIENT: 172.16.9.2]
2006-12-20 16:24:00.06 Logon Error: 18456, Severity: 14, State: 16.
2006-12-20 16:24:00.06 Logon Login failed for user 'PRI\sqlservice'. [CLIENT: 172.16.9.2]
2006-12-20 16:24:01.06 Logon Error: 18456, Severity: 14, State: 16.
2006-12-20 16:24:01.06 Logon Login failed for user 'PRI\sqlservice'. [CLIENT: 172.16.9.2]
2006-12-20 16:24:01.07 Logon Error: 18456, Severity: 14, State: 16.
2006-12-20 16:24:01.07 Logon Login failed for user 'PRI\sqlservice'. [CLIENT: 172.16.9.2]
2006-12-20 16:24:03.84 Logon Error: 18456, Severity: 14, State: 16.
2006-12-20 16:24:03.84 Logon Login failed for user 'PRI\sqlservice'. [CLIENT: 172.16.9.2]
2006-12-20 16:24:03.85 Logon Error: 18456, Severity: 14, State: 16.
2006-12-20 16:24:03.85 Logon Login failed for user 'PRI\sqlservice'. [CLIENT: 172.16.9.2]
2006-12-20 16:24:03.96 Logon Error: 18456, Severity: 14, State: 16.
2006-12-20 16:24:03.96 Logon Login failed for user 'PRI\sqlservice'. [CLIENT: 172.16.9.2]
2006-12-20 16:24:03.98 Logon Error: 18456, Severity: 14, State: 16.
2006-12-20 16:24:03.98 Logon Login failed for user 'PRI\sqlservice'. [CLIENT: 172.16.9.2]
2006-12-20 16:24:41.41 Logon Error: 18456, Severity: 14, State: 16.
2006-12-20 16:24:41.41 Logon Login failed for user 'PRI\sqlservice'. [CLIENT: 172.16.9.2]
2006-12-20 16:24:41.41 Logon Error: 18456, Severity: 14, State: 16.
2006-12-20 16:24:41.41 Logon Login failed for user 'PRI\sqlservice'. [CLIENT: 172.16.9.2]

Just found out its someone running a script to get into our server.|||That wasn't it. The same server is the one trying to log in. I have database mail turned on, too.

Error: 18456, Severity: 14, State: 16

DBCC TRACEON 4808, server process ID (SPID) 58. This is an
informational message only; no user action is
required.
2007-02-26 16:01:43.270 spid58 DBCC TRACEON 4808, server process
ID (SPID) 58. This is an informational message only; no user action is
required.
2007-02-26 16:02:12.590 spid62 Starting up database
'MYDB'.
2007-02-26 16:02:34.840 spid62 Starting up database
'MYDB'.
2007-02-26 16:02:47.410 Logon Error: 18456, Severity: 14,
State:
16.
2007-02-26 16:02:47.410 Logon Login failed for user 'NT
AUTHORITY\SYSTEM'. [CLIENT: <local
machine>]
2007-02-26 16:02:48.580 Logon Error: 18456, Severity: 14,
State:
16.
2007-02-26 16:02:48.580 Logon Login failed for user 'NT
AUTHORITY\SYSTEM'. [CLIENT: <local
machine>]
2007-02-26 16:02:50.410 Logon Error: 18456, Severity: 14,
State:
16.
2007-02-26 16:02:50.410 Logon Login failed for user 'NT
AUTHORITY\SYSTEM'. [CLIENT: <local
machine>]
2007-02-26 16:02:52.930 spid55 Starting up database
'sampledb'.
2007-02-26 16:02:59.160 Logon Error: 18456, Severity: 14,
State: 16.
The Connection is maded from .net application using trusted connectionIt looks like you're running your .NET application as LocalSystem. You
need to run it as a user who has an account defined in the database with
the appropriate credentials. If you're running an ASP.NET app on
Windows 2003, you'll generally be able to find the configuration for
your identity under "Application Pools" in the IIS configuration.
AMBROSE wrote:
> DBCC TRACEON 4808, server process ID (SPID) 58. This is an
> informational message only; no user action is
> required.
> 2007-02-26 16:01:43.270 spid58 DBCC TRACEON 4808, server process
> ID (SPID) 58. This is an informational message only; no user action is
> required.
> 2007-02-26 16:02:12.590 spid62 Starting up database
> 'MYDB'.
> 2007-02-26 16:02:34.840 spid62 Starting up database
> 'MYDB'.
> 2007-02-26 16:02:47.410 Logon Error: 18456, Severity: 14,
> State:
> 16.
> 2007-02-26 16:02:47.410 Logon Login failed for user 'NT
> AUTHORITY\SYSTEM'. [CLIENT: <local
> machine>]
> 2007-02-26 16:02:48.580 Logon Error: 18456, Severity: 14,
> State:
> 16.
> 2007-02-26 16:02:48.580 Logon Login failed for user 'NT
> AUTHORITY\SYSTEM'. [CLIENT: <local
> machine>]
> 2007-02-26 16:02:50.410 Logon Error: 18456, Severity: 14,
> State:
> 16.
> 2007-02-26 16:02:50.410 Logon Login failed for user 'NT
> AUTHORITY\SYSTEM'. [CLIENT: <local
> machine>]
> 2007-02-26 16:02:52.930 spid55 Starting up database
> 'sampledb'.
> 2007-02-26 16:02:59.160 Logon Error: 18456, Severity: 14,
> State: 16.
> The Connection is maded from .net application using trusted connection
>

Error: 18456, Severity: 14, State: 16

DBCC TRACEON 4808, server process ID (SPID) 58. This is an
informational message only; no user action is
required.
2007-02-26 16:01:43.270 spid58 DBCC TRACEON 4808, server process
ID (SPID) 58. This is an informational message only; no user action is
required.
2007-02-26 16:02:12.590 spid62 Starting up database
'MYDB'.
2007-02-26 16:02:34.840 spid62 Starting up database
'MYDB'.
2007-02-26 16:02:47.410 Logon Error: 18456, Severity: 14,
State:
16.
2007-02-26 16:02:47.410 Logon Login failed for user 'NT
AUTHORITY\SYSTEM'. [CLIENT: <local
machine>]
2007-02-26 16:02:48.580 Logon Error: 18456, Severity: 14,
State:
16.
2007-02-26 16:02:48.580 Logon Login failed for user 'NT
AUTHORITY\SYSTEM'. [CLIENT: <local
machine>]
2007-02-26 16:02:50.410 Logon Error: 18456, Severity: 14,
State:
16.
2007-02-26 16:02:50.410 Logon Login failed for user 'NT
AUTHORITY\SYSTEM'. [CLIENT: <local
machine>]
2007-02-26 16:02:52.930 spid55 Starting up database
'sampledb'.
2007-02-26 16:02:59.160 Logon Error: 18456, Severity: 14,
State: 16.
The Connection is maded from .net application using trusted connectionIt looks like you're running your .NET application as LocalSystem. You
need to run it as a user who has an account defined in the database with
the appropriate credentials. If you're running an ASP.NET app on
Windows 2003, you'll generally be able to find the configuration for
your identity under "Application Pools" in the IIS configuration.
AMBROSE wrote:
> DBCC TRACEON 4808, server process ID (SPID) 58. This is an
> informational message only; no user action is
> required.
> 2007-02-26 16:01:43.270 spid58 DBCC TRACEON 4808, server process
> ID (SPID) 58. This is an informational message only; no user action is
> required.
> 2007-02-26 16:02:12.590 spid62 Starting up database
> 'MYDB'.
> 2007-02-26 16:02:34.840 spid62 Starting up database
> 'MYDB'.
> 2007-02-26 16:02:47.410 Logon Error: 18456, Severity: 14,
> State:
> 16.
> 2007-02-26 16:02:47.410 Logon Login failed for user 'NT
> AUTHORITY\SYSTEM'. [CLIENT: <local
> machine>]
> 2007-02-26 16:02:48.580 Logon Error: 18456, Severity: 14,
> State:
> 16.
> 2007-02-26 16:02:48.580 Logon Login failed for user 'NT
> AUTHORITY\SYSTEM'. [CLIENT: <local
> machine>]
> 2007-02-26 16:02:50.410 Logon Error: 18456, Severity: 14,
> State:
> 16.
> 2007-02-26 16:02:50.410 Logon Login failed for user 'NT
> AUTHORITY\SYSTEM'. [CLIENT: <local
> machine>]
> 2007-02-26 16:02:52.930 spid55 Starting up database
> 'sampledb'.
> 2007-02-26 16:02:59.160 Logon Error: 18456, Severity: 14,
> State: 16.
> The Connection is maded from .net application using trusted connection
>

Error while trying to execute a user defined function

Hi,

I'm working on SQL SERVER 2005 Standard edition.

I created a user defined function on the dbo schema.

Is it possible to invoke a user defined function in a select clause only with the name of this function without precising the name of the schema.

if my function is called TOTO(), can i execute the command :

SELECT TOTO()

go

Actually when i try to execute this command i have the following error message :

Message 195, level 15, state 10 :

'TOTO' is not a known built-in function name option.

Can someone help me to solve this issue ?

try

select dbo.toto()

|||

I know that it works but i want to know if it's possible to execute this function without specifying the schema just like this :

SELECT toto()

go

|||

Locolito:

The response to your question is no: WIth a scalar function you must supply the "schema" qualifier -- such as dbo; however, the schema qualifier is not required with a table function.

Dave

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

Error while connecting Analysis Manager

Hi,

I try to connect a distant analysis manager server. My user is declared as Administrators in the distant server. I'm Administartor too on my PC

When I try to connect this server (via IP adress) a error appears :

Cannot connect to the repository

Analysis server : ip adress here

Error:
'\\<nameOfDistantServer>\MSOLAPRepository$\msdrep.mdb' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on wich the file resides.

Someone can help me ?

Thanks

moustachuRefer to the registry for the key [HKLM\Software\Microsoft\OLAP Server\Server ConnectionInfo\RemoteRepositoryConnectionString] and edit the value with the valid path.|||I will try as soon as possible

Thanks