Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







Unable To Find / Start SQL Services Or Add Vista User Into Admin Role


Sorry if this is a simple question, I've not seen any similar posts.

I'm just finished installed SQL 2005 on Vista Business edition (first time for both).  I subsequently installed SP2 for 2005.

Upon completing the SP2 installation, the SQL Server Surface Area Configuration manager opened asking me to grant admin rights to the account I used to install the software.  The account I used is the local admin account on the machine (only account on the machine as this is my dev box) . 

 

Nothing shows in the two boxes below on this dialog, "Available Privelages" is blank and "Privelages granted is blank".

 

In addition, if I go to SQL Server Configuration Manager, and click on SQL Server 2005 Services, nothing shows in the right pain. It's as if the software installed, and yet no instance of the database exists or is running.

 

My thought was that the admin account I used to install the software doesn't have sufficient privelages to to start the SQL Server or SQLBrowser. So I went to computer management, Local Users and groups (machine isn't on a network yet), and made sure this same account is part of the administrators group.

 

Any ideas on how I should solve this?


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
User Provisioning Tool For Vista (creating System Admin Accounts
I am reading kb 934164. I am confused about (creating system administrator) domain user accounts....
IN SQL 2005 USER PROVISIONING Tools  
under  kb934164 8e type a window account by the following format 
 domain/user     8k Type a windows account by following format domain/user  
DO I simply type domain/user or do I actually Type my domain/user account 
What is domain user? 
In other words where does domain (PASSWORD)  come from? 
where does user(PASSWORD)  come from?
I have being trying to find the answer for this  
Is there anything else I need to be prepared for in user
provisioning. By the way do you need to turn off uac in vista while installing
sql 2005....Thanks    Is there any examples of this? I just want to get it right....
   

View Replies !   View Related
Unable To Remove User From Public Role ?
Can anybody explain what database user with a prefix of "" in the public role indicates. I have the same two users in every database and cannot remove them?

Any help would be gratefully received.

View Replies !   View Related
Find Out If Current User Is Member Of A Role
I need a stored procedure to find out if the current user is a member of a certain role. I want to pass the role name and return a bit to tell whether he is a member or not. I have this code to list the groups the current user is a member of but I don't know how to search or do a "SELECT FROM" on the results.DECLARE @usr varchar(32) SET @usr = USER EXEC sp_helpuser @usr But if the current user is a member of more than one role it returns multiple rows. So if I could do something like: DECLARE @grpName varchar(32) SELECT * FROM (EXEC sp_helpuser @usr) WHERE GroupName=@grpNameIF rowcount > 0 THENRETURN 1ELSERETURN 0END IF I know that doesn't work so how can I do this?

View Replies !   View Related
Unable To Install Reporting Services On Vista
Hi ,

i'm a new to vista and also with sql server 2005 reporting services ..

i was able to install all the tools in sql2005 express edition except reporting services ..gives a message IIS required ..even though the IIS is running and able to browse http://localhost  ..

can any one give me an idea , how to install reporting services on vista with IIS7

 

Thanks

 

View Replies !   View Related
Unable To Start MS SQL Server Services
I have a client server application and it is running in the following configuration: SERVER A: MS Server2003 with MS SQL2000, Our ERP application software is installed on this server as is MS SQL200.

Server B: is our e-commerce server and it is running MS Windows2000 server OS and no MS SQL. The e-commerce application is pointed to the active SQL server on server A. I am trying to run a software version upgrade on on software application (which was successfully run on server A) When we try to run this upgrade on server B we get a message: " Setup is unable to start MS SQL Server Services, please start and try again"

I do not understand what is going on with this. SQL & SQL Service Agent is running on Server A. Any suggestions as to what I need to do?

www.accellus.com

View Replies !   View Related
Unable To Configure Reporting Services With Vista/IIS7
I am trying to configure a reporting server on my laptop at work.  This laptop is running Vista and IIS 7.  When I install reporting services, the option for "Install the default configuration" is disabled (greyed out) during setup.  The install is successful, but then when I try to connect in the Reporting Services Configuration Manager, I get an unhandled exception ("A WMI error has occurred an no additional error information is available.").  If I continue, this error continues to crop up as I attempt to configure the Report Server.  When I attempt to configure the virtual directory, the configuration manager crashes.  Then, when I navigate to the reportserver page, I get a page that states:
Server Application Unavailable

The web application you are attempting to access on this web server is currently unavailable.  Please hit the "Refresh" button in your web browser to retry your request.

Administrator Note: An error message detailing the cause of this specific request failure can be found in the application event log of the web server. Please review this log entry to discover what caused this error to occur.

Any ideas for a solution or workaround would be greatly appreciated.

Thanks,

Dave 

View Replies !   View Related
Unable To Start Reporting Services On Local Machine
I am new to SQL Server 2005 Reporting Services and I€™m having problems starting the service.  I am running a Windows XP SP2 with SQL Server 2005 and reporting services but the service will not start.  My SQL Server instance logs on using €˜Windows Authentication€™ using a username sysadm with no password
 
I have installed IIS and made sure that ASP.net is running.
 
I have opened up the Report Services Configuration Manager and amended the settings but I€™m unable to get the service started!!!
 
Theses are my settings
 
i)          Report Server Virtual Directory OK
Name: ReportServer1
Website:  Default Web Site
 
ii)         Report Manager Virtual Directory
                        Name: Reports1
                        Website: Default Web Site
 
iii)         Windows Service Identity
                        Service name: ReportServer
                        Service Account: NT AuthorityLocal Service
 
Iv         Web Service Identity                            (NOT WORKING)
                                   
 
v)         Database Setup
                        Servername €“ Nameofmyserver
                        Database name  - ReportServer1
                        Credential Type Server Credentials
 
           
When I click on start no error message appears, it just seems to time out.

View Replies !   View Related
Unable To Start SQL Server In Single User Mode...
I am trying to migrate a instance , while trying to rename the server i am getting the following error.

 

Error: Instance name exceeds maximum length

Aborting Initialization

 

The instance name is 20 char long.

 

Please let me know if there is any workaround.

 

Thanks in advance.

View Replies !   View Related
Unable To Start SQL Express 2005 Service As A Network User
I am trying to start ms sql server 2005 express as a network user from originally starting as local system. I cannot start the service.

I have given this network user administrator access to sql express from the sql server surface area configuration "Add New Administrator". I have went into the local users/groups and added this network user to the 3 security groups

SQLServer2005MSSQLServerADHelperUser$SQL1
SQLServer2005MSSQLUser$SQL1$SQLEXPRESS
SQLServer2005MSSQLBrowserUser$SQL1


I receive one alert int he event logs/application

EventID: 26010

The server could not load the certificate it needs to initiate an SSL connection. It returned the following error: 0x8009030d. Check certificates to make sure they are valid.

I receive five errors in the event logs/application

EventID: 26014

Unable to load user specified certificate. The server will not accept a connection. You should verify that the certificate is correctly installed. See "Configuring Certificate for Use by SSL" in Books Online.

EventID: 17182

TDSSNIClient initialization failed with error 0x80092004, status code 0x80

EventID: 17182
TDSSNIClient initialization failed with error 0x80092004, status code 0x1

EventID: 17826

Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately prceding this one in the error log.

EventID: 17120

SQL Server could not spawn the FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.

I don't recall assigning any sql specific certificates. The reason I'm trying to run this as a network user is because an application on a remote windows server requires it.

After starting the service back running as local system as it was before, I went into the
SQL Server Management Studio Express and edited the properties for this new network user I wish to run the service as. I gave him full access including checking all grants in securables.

I now see a bit of a difference in the event logs with these errors.

EventID: 17058

initerrlog: Could not open the log file 'c:Program FilesMicrosoft SQL ServerMSSQL1MSSQLLOGERRORLOG.' Operating system error =5(Access is denied).

I saw a notification when changing the sql server service's logon that the new network user has been granted the log on locally right.

The second and last new error is

EventID:  17053

UpdateUptimeRegKey: Operating system error 5(Access is denied.) encountered.

View Replies !   View Related
Admin Or Other Role
I have one other question.  How do you define roles?  What role(s) are required to fully administer SQL Server? What role(s) are required to fully administer a single database in SQL Server?

thanks,

View Replies !   View Related
How To Start Using Admin Name
Hi,

I went to services in sql server 2000 and stoped that and i right clicked my mssql server and clicked on logon button and enter the username and password.So knw i want to access my database through that admin name and password .How to do that.

Kindly reply for this mail.

Thanks & Regards,
Swar.

View Replies !   View Related
Trying Write File For RS Utility To Put The Admin Group As Having The Role To Edit Newly Made Folders
 

Hi there,
 
I am trying to write some script for the RS Uitility that will put a group called MyReportsAdmins as having the role to edit the my reports folders that are created whenever a new user is created.
 
I am looking for the syntax that will allow me to set the folder "My Reports" security to allow the MyReportsAdmins group to edit it.
 
Public Sub Main()
 Dim items() As CatalogItem
 Items = rs.ListChildren("/Users Folders", True)
 For Each item As CatalogItem In items
  If item.name = "My Reports" and if item.type = 'folder' then item.set.security "
 
 Next Item
End Sub
 
I don't know if this will help but this is a vague psuedo code that I was just using to organize my thoughts on how to start this.

 
Any and all help appreciated.
Jreg

View Replies !   View Related
Help Again Please! Unable To Connect To The ADMIN$ Share
OK, I can get to the admin$ share, see all the files contained within, but I still get this message. Help! I really need to upgrade this 6.5 db and i keep running into these damn errors!


Stefanie

View Replies !   View Related
Unable To Login To Database Created By Admin
Using SQL Server 2005 under XP Professional.  I am attempting to log into the Server Management Studio as "UserX".  I had previously been using Server Management while logged in as admin.
 I now get this error message when attempting to connect to the database server:
 **********************************************************************TITLE: Connect to Server------------------------------Cannot connect to [**NAME OF SERVER**].------------------------------ADDITIONAL INFORMATION:Login failed for user '[**NAME OF SERVER**].UserX. (Microsoft SQL Server, Error: 18456)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476------------------------------BUTTONS:OK------------------------------
*******************************
 Microsoft help doesn't have a specific help for that particular error message.  Any hints as to what is going wrong?

View Replies !   View Related
Setting Admin Rights To Report Manager, SQL Server Express 2005 On Vista Business
Hi all,

I'm a newbie to Reporting Services so please forgive my ignorance...

I've recently installed SQL Server Express 2005 with Reporting Services on my Vista Business Notebook (with no network connections) and have installed VS C# Express as well as the Business Intelligence Studio to create reports.

My C# application can connect to SQL Server fine, however, the reports I created with Business Studio refuses to deploy to the server due to the following reason:

"The permissions granted to user 'localhostJenny' are insufficient for
performing this operation".

I find this odd as I've been able to deploy reports on my other Windows XP machine (with SQL Server Express) no probs at all.  Additionally, I cannot see the 'Site settings' link within Report Manager (Web) that I'd normally get with an admin account (i.e. on my Win. XP machine).  Various sources indicate that my account has insufficient access rights to view this.

Having browsed through seemingly endless blogs and forums, I suspect that my local account has not been configured to access the Report Manager web client to publish, manage and administer the site.

I have tried the surface area tool for SQL Server, but I suspect that this is relevant only to SQL Server DB access and management.  Adding an administrator here does nothing.

The question is, how can I grant access to myself (local account) to allow me to publish reports via business studio, and at the same time - administer Report Manager Site Settings - on my vista notebook??

I would be extremely grateful for any help on this matter - I've tried ceaseless reinstallations, but to no avail!


Many thanks in advance,

Jenny

View Replies !   View Related
Programmatically Adding A User To The System User Role
We have been working on an application that will be using a forms-authenticated report server (RS2005) as a reporting back-end. Using the reporting services web service I have been able to assign permissions to objects in reporting services no problem. The issue is that each user needs to be added to the System User role to be able to use the report builder properly. I can't seem to find a way to do this programmatically. Any idea?

View Replies !   View Related
Unable To Run SQL Agent With A Service Account Not In Admin Group
Am trying to run SQL Server Agent with a service account which is not in the Administrators group. Have done the following -
1. Removed the service account from the Administrators group on the machine
2. Assigned sysadmin privileges to the service account
3. Added it to the SQLServer2005SQLAgentUser$ComputerName$MSSQLSERVER role
4. Through SQL Configuration Manager assigned this account to the SQL Server Agent service
However, this does not start the Agent as a service. What is it that is missing?

View Replies !   View Related
6.5 Question - Unable To Revoke SA Permission From Local Admin Group
We have a SQL Server 6.5 instance that has yet to be upgraded to SQL 2000. (Long story). Anyhow, I'm trying to revoke SA permission from the local administrators group, which SQL Server grants by default during setup. I followed the instructions on BOL, but no luck. Here is what I've tried.

Changed my desktop client from named pipes to TCP/IP
Verified the server client allows TCP/IP and named pipes (needed for old applications)
Changed security mode to Mixed
Created a local group called DBA_Admin
Granted DBA_Admin SA permission through SQL Security Manager
Revoked SA permission from Administrators group (local admin group on server)
Added my domain group to DBA_Admin

Unfortunately someone who is a member of the local administrators group, but not DBA_Admin group, is able to still access the SQL Server instance from Enterprise Manager using a trusted connection. Why???????????

Thanks, Dave

View Replies !   View Related
Adding A User/role To All User Database
Hi everyone,

I try to add a db_role or a user to all my databases with one script. Although parsing doesn't report any problem I get a Syntax error during execution.
I first select the database names into a #temp table which has two columns, ID and dbname.
After that I use the following code:

DECLARE @Count smallint
declare @dbVarchar(20)

SET @Count = 1

WHILE (@Count <=(SELECT MAX(ID) FROM #temp))

BEGIN

Exec ("USE @db")

EXEC sp_adduser 'test'
EXEC sp_addrolemember 'my_role', 'testrole'


SET @COUNT = @COUNT + 1
SET @db = (SELECT dbname FROM #temp WHERE ID = @Count)
END

It seems that the "Use @db" part has no value for the variable @db.
Does anybody knows how to solve this?

View Replies !   View Related
Sql Server Service Wont Start After Vista Updates
hey

I have a notebook with windows vista ultimate edition. For developement i have Ms visual studio 2005 and sql server 2005(with all the required and latest SPs) on it. For the past few months i have been working on the machine without any hitches. Just 2 -3 days back some windows updates got installed on the machine and guess what!!!!!! the sql server service just stopped working. The service wont start no matter what. I
have tried almost solution that i came across on the internet and it wont work out. I unistalled and reinstalled the server as but to no avail. The database engine now wont intall as the sql service wont start during the server installlation.

While browsing through the internet i didnt come across anyone with a similar problem! Am i the first one to be in such a situation
give your comments and share any relevant experience.

P.s the windows upgrades installed on the system were all security upgrades so why should they effect the sql server working.

Rgds

View Replies !   View Related
Sql Server Service Wont Start After Vista Upgrades
 

hey

I have a notebook with  windows vista ultimate edition. For developement i have Ms visual studio 2005 and sql server 2005(with all the required and latest SPs) on it. For the past few months i have been working on the machine without any hitches. Just 2 -3 days back some windows updates got installed on the machine and guess what!!!!!! the sql server service just stopped working. The service wont start no matter what. I
have tried almost solution that i came across on the internet and it wont work out. I unistalled and reinstalled the server as but to no avail. The database engine now wont intall as the sql service wont start during the server installlation.

While browsing through the internet i didnt come across anyone with a similar problem! Am i the first one to be in such a situation
 give your comments and share any relevant experience.

P.s the windows upgrades installed on the system were all security upgrades so why should they effect the sql server working. 

Rgds

View Replies !   View Related
Local Admin On Report Services
Good grief the tech are telling me that the reason I cant connect to report services is becasue I need to be a Local Admin, I can connec to the database engine but not Report services. Yikes

help??

View Replies !   View Related
Login Failed For User 'Admin'.
Provider=SQLOLEDB.1;Persist Security Info=False;User ID=Admin;Initial
Catalog=Northwind;Data Source=LocalNet;Use Procedure for Prepare=1;Auto
Translate=True;Packet Size=4096;Workstation ID=LocalNet;Use Encryption for
Data=False;Tag with column collation when possible=False

Any ideas on how to solve this problem?

Cheers

View Replies !   View Related
Login Failed For User &#39;Admin&#39;
The NT Event Viewer for our SQL Server machine, constantly logs the error:

18456: Login failed for user 'Admin'

I don't have a user or group called 'Admin' in either NT User Manager or in SQL Server users.
Event Viewer tells me that:
Source: MSSQLServer.
Computer: SERVER_SQL (The NT 4 SQL Server machine)
Type: Information
Category: Logon

My I.T. Manager would like me to get rid of the event.
Any suggestions please as to where it is coming from and how I can get rid of it?

Thanks

Geoff Collishaw - Melbourne, Australia

View Replies !   View Related
SQL Server Unable To Connect On Vista
I have a problem that unble to connect the SQL Server2005 on Vista OS. After searching solution around but still not able to find the solution for me problem.
The Error was Error 26,
provider:SQL network interfaces, error:26 - error locating server/instance specified
 
Is any1 facing the problem on this? Any solution for this case?
 
TQ
 

View Replies !   View Related
Unable To Connect After Installing Vista SP1
Hi,
 
I am using Sql server 2005 on our local network. I have an vpn open to an other network.
Before installing Vista SP1, I could simple connect to the db (sql server management studio, windows authentication).
 
After installing Vista SP1, I can connect to sql server when the vpn is closed. But when the vpn is open, I get the following message:
 
Login failed for user ''. The user is not associated with a trusted SQL Server connection. (.Net SqlClient Data Provider)
 
Does anyone have a clue?
 
Perry
 

View Replies !   View Related
Unable To Setup On Windows Vista
Hello,

I cannot install SQL Server 2005 Express Edition on Windows Vista (Build 6000). I am logged on as the administrator. I tried to setup SP1 version, but it didn't work. Neither did after applying SP2 version.

What can be the reason? On the Problem Reports and Solutions panel it tells me to update to SP2. But it doesnt work.

View Replies !   View Related
Analysis Services Admin Access To One Database Only
On a given Analysis Server the machine level OLAP Administrators group controls which users have admin access to AS Databases and Cubes on that machine. From everything I have read, if you are in the OLAP Administrators group you have full access to administer ALL the databases and cubes.
We have a need to create a OLAP database and grant a few users (a role) full admin access to create and maintain datasouces and cubes within that database but NOT allow them admin access to the other existing databases and cubes on the server.  This seems like such a common requirement. Has anyones else encountered and resolved this issue.
Thanks,
Tony

View Replies !   View Related
Reporting Services Not Showing In Central Admin
I downloaded and installed SQL Server 2005 SP2 update on my reporting services server.  I think downloaded and installed the share point reporting services admin to my share point dev server.  I open up the central administration and there is no reporting services menu option under the Application menu.  The sharepoint server is a farm with backend database on one server and all the web apps on the other (where the add-in was installed).  The reporting server is a separate server running its own instance of SQL 2005.

Am I missing something with this setup?

View Replies !   View Related
What Role Should Be Given To The End User?
Hi Everybody,

The end users are using VB Applications, there they will be entering datas. Those datas will be stored in the SMS Database.

My Problem is through which Roles (Fixed Server Roles or Database Roles) I should attach these end users. If it is a Fixed Server Roles, Other than sysadmin role in which role I should attach this end user. Like that other than DB_Owner in which role I should attach these end users to the Database Roles.

Can anyone guide me please.

thanks,
Srinivasan.

View Replies !   View Related
SQL USER's ADMIN RIGHTS ON RESTORED DATABASE
Thanks in advance for help.
 
Could someone please help me for SWL backup restoration and db by user
 
I restored SQL 7.0 database to SQL 2000. ( by creating empty db on SQL 2000 and restored  from SQL 7 backup) -- restore ok..
I need to use same SQL user which is admin for DB on  SQL 7,  for  SQL 2000 also. (  DB user is sql user not domain user)
I put mixed authentication mode ( windows and SQL) in SQL 2000 enterprises manager security tab setting.  
I can see DB user is available in DB user list on restored DB but can not access DB when I try to access from query analyser
I tried to create new login with same name as it was in SQL 7 and tried to give full admin access on SQL 2000 enterprise manager but I get error 21002:[ SQL DMO] User 'user' already exists.
 
Kind Regards
Sunod
 

View Replies !   View Related
Unable To Connect To A Remote Database From Vista
We have a problem to connect to a specific database on our local network from a specific Vista machine. Several other XP and Vista machines are able to connect to the database without any problem. However, with the two latest Vista machines we received, it is impossible to connect to the database. In Microsoft SQL server Management studio express, we have the error 26 "error locating server/instance specified". We are sure the server name we entered is correct. We suppose the server is correctly configured as we are able to connect from other computers. From the machines that are not able to connect to the database, we can connect without problem to other databases. We also see the server, where the database is, on the network servers list in Microsoft SQL server Management studio. .
The version of the components are:
Microsoft SQL Server Management Studio Express                9.00.3042.00
Microsoft Data Access Components (MDAC)                        6.0.6000.16386 (vista_rtm.061101-2205)
Microsoft MSXML                        3.0 4.0 6.0
Microsoft Internet Explorer                        7.0.6000.16575
Microsoft .NET Framework                        2.0.50727.312
Operating System                        6.0.6000
We verified we have the same version of components on the Vista machine from which the connection is successful.
The network database has the version 8.0.
We are usinng sql server authentification method.
We try to specify the IP address instead of the server name in the connection string. We also tried to specify the port.
We also tried to disable the firewall.
Unfortunatetly, we are not able to connect to this database. Any suggestion ?

View Replies !   View Related
Unable To Install SQL Server Express (SP1 Or SP2) On Vista
I am unable to install Business Contact Manager for Outlook 2007.  I sought help in the BCM forum, but the developer who I spoke with came to the conclusion that it is a SQL Server Express problem that I am experiencing, and so he recommended that I come here for help.

I am running on Vista Ultimate.

Every attempt I have made to install BCM (and later SQL Express Server 2005 separately, see below) has failed at the same point, with the same error message:

"SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client][SQL Server]Login failed for user 'sa'.

Today I attempted to install SQL Express Server SP2 separately on its own, the idea being that if this worked, then I might be able to install BCM on top of it.  I attempted the SQL EE SP2 installation after uninstalling all remnants of previous installations to the best of my ablity. The SP2 installation failed at the same point, and had the same appearance, as I saw in all prior attempts.  (The installer reported no errors or warnings in its system checks prior to beginning the actual install.)

Here is the summary log from this trial:


Microsoft SQL Server 2005 9.00.3042.00 ============================== OS Version      : Professional  (Build 6000) Time            : Tue Apr 03 15:39:02 2007  Machine         : LUMACRAFT-1 Product         : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.3042.00 Install         : Successful Log File        : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_LUMACRAFT-1_SQLSupport_1.log -------------------------------------------------------------------------------- Machine         : LUMACRAFT-1 Product         : Microsoft SQL Server Native Client Product Version : 9.00.3042.00 Install         : Successful Log File        : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_LUMACRAFT-1_SQLNCLI_1.log -------------------------------------------------------------------------------- Machine         : LUMACRAFT-1 Product         : Microsoft SQL Server VSS Writer Product Version : 9.00.3042.00 Install         : Successful Log File        : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_LUMACRAFT-1_SqlWriter_1.log -------------------------------------------------------------------------------- Machine         : LUMACRAFT-1Product         : SQL Server Database ServicesError           : SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client][SQL Server]Login failed for user 'sa'. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.--------------------------------------------------------------------------------Machine         : LUMACRAFT-1 Product         : Microsoft SQL Server 2005 Express Edition Product Version : 9.2.3042.00 Install         : Failed Log File        : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_LUMACRAFT-1_SQL.log Last Action     : InstallFinalize Error String    : SQL Server Setup could not connect to the database service for server configuration. The error was: {Microsoft}{SQL Native Client}{SQL Server}Login failed for user 'sa'. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online. Error Number    : 29515 --------------------------------------------------------------------------------

The pertinent section from the SQLSetup0008_user_SQL.log seems to be:

MSI (s) (F0:88) [15:42:00:403]: Invoking remote custom action. DLL: C:WindowsInstallerMSI118F.tmp, Entrypoint: Do_sqlScript<Func Name='LaunchFunction'>Function=Do_sqlScript<Func Name='GetCAContext'><EndFunc Name='GetCAContext' Return='T' GetLastError='203'>Doing Action: Do_sqlScriptPerfTime Start: Do_sqlScript : Tue Apr 03 15:42:00 2007Service MSSQL$SQLEXPRESS with parameters '-m SqlSetup -Q -qLatin1_General_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Tue Apr 03 15:42:00 2007SQL service MSSQL$SQLEXPRESS started successfully waiting for SQL service to accept client connectionsService MSSQL$SQLEXPRESS started at Tue Apr 03 15:42:05 2007SQL_ERROR (-1) in OdbcConnection::connectsqlstate=28000, level=-1, state=-1, native_error=18456, msg=[Microsoft][SQL Native Client][SQL Server]Login failed for user 'sa'.        Error Code: 0x80074818 (18456)Windows Error Text:   Source File Name: libodbc_connection.cppCompiler Timestamp: Wed Jun 14 16:28:15 2006     Function Name: OdbcConnection::connect@connectSource Line Number: 148---- Context -----------------------------------------------Connecting to SQL ServerExecuteSqlCommandsOriginial error was 80074818 (18456)iptSqlScriptHlprError Code: 18456Other things that I have tried include disabling UAC, and running BCM setup.exe 'as administrator'.

Any advice on how to get SQL EE installed, so that I can ultimately install BCM, will be greatly appreciated.

Thanks,

David A. Gilmour

View Replies !   View Related
Unable To Start SQL Executive 6.5
I'm unable to start the SQL Exceutive: The last entry in the excutive error log file is "Task refresher support Thread stopped". If I go into manage schedule task and then select the tab "running task" the process just hangs...

View Replies !   View Related
Unable To Start SQL Service
I am unable to start SQL service on my system after i rebooted it

following is the message that i get
SQL Service on Local Computer started and then stopped. Some service stop automatically if they have no work to do

following is the corresponding entry in event viewer
TDSSNIClient initialization failed with error 0x7e, status code 0x60.

View Replies !   View Related
Unable To Start Server
My Server service will not start, i get a message saing consult the logs, in the error logs it says error in the model db .ldf file. However, i can not connect to the server to restore from my back ups. I get the error msg, your server may not be configured to accept remote connection. No, i dont know what im doing and my only though is to start from scratch reinstalling the server. Any help is apreciated.

View Replies !   View Related
Unable To Start T-SQL Debugger
HI:

     I'm using VB6, I try to run the debugging process, Well I get this message.

I run through this forum, most were with Studio 2005. Can Some one help?

View Replies !   View Related
Unable To Start SQLEXPRESS
Hi

I have downloaded and installed the trial version of MS Visual Studio 2005 Team System. The installation was successful. However, I am not able to start SQLEXPRESS using the SQL Server Configuration Manager. It shows me SQLEXPRESS but when I right click and select Start it tries to start the service and after some time gives the following error

"The request failed or the service did not respond in a timely fashion. Consult the event log or other applicable error logs for details."

The event log shows the following errors:

1. FCB::Open: Operating system error 5(Access is denied.) occurred while creating or opening file 'c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmastlog.ldf'. Diagnose and correct the operating system error, and retry the operation.

2. FCB::Open failed: Could not open file c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmastlog.ldf for file number 2. OS error: 5(Access is denied.).

I tried enabling remote connections but still got the same error.

Please help.

Regards

Rajat

View Replies !   View Related
Installing Sql Server 2005 On Vista - Can't Find
I tried to install SQL Server 2005 Developer Edition on my laptop with Vista Business but I have gone through installation process a couple times and I can't seem to find SQL Management Studio.  The install setup.exe files even tell me that there is nothing left to install when I run them.  I have done all SP updates with installation and VS2005 is also already installed.  But when I search the "all programs" directory I only have the below options under SQL Server 2005/Configuration Tools:
- Notification Services- SQL Server Configuration Manager- SQL Server Error & Usage Reporting- SQL Surface Area Configuration
Is the Management Studio somewhere in the above options or do I need to uninstall and re-install (hopefully not).
Thanks!

View Replies !   View Related
User/Role Check
Can anyone out there help me write a sp to determine if a user has a certain role?

I'm trying to use "sp_helpuser @UserName".

Can I declare a cursor with "EXEC sp_helpuser @UserName"? I'm not having success with this.

What about SELECT [GroupName] FROM EXEC sp_helpuser @UserName WHERE [GroupName] = @GroupName? Again, syntax error.

Is there already a better way that someone knows of?

View Replies !   View Related
User With Server Role
I have a user with DBCREATOR Server role only. That user is able to create database but create table permission denied.
how would I set permission on this user, so that this user can create databases and automatically becomes the DBOWNER of that database and can do any action on that database.
 
Thanks,
 

View Replies !   View Related
Unable To Connect - SQL Express On Server 2003 From Vista
Getting error 1326.

I'm running SQL Express on Server 2003 SP1 (workstation - although, I did dcpromo promote and demote prior to installing SQL Express).

I'm trying to connect from SQL Studio Express on Vista.

TCP and Named Pipes are selected in Surface Area Config; sp_config remote, access..., 1 was run (per KB); ports 1433 & 1434 are open (I think 435 also was opened when I ran the KB instructions); Mixed mode is selected, user is set for SQL Auth, password is correct; all permissions are granted. 

I found an article online which stated that mixed versions of MDAC can lead to the problem. The server has 2.82.1830 and the client has 6.0.5600.16834. Could this be the problem? If so, how to solve?

Thanks, John

 

View Replies !   View Related
Migration Problems From SQL 2000 To SQL 2005: User Cannot Find The User 'RSExecRole'
 

Hello,

 

I am trying to migrate reporting services from SQL server 2000 to SQL 2005. I followed the migration steps listed in one of the TechNet documents. Installed SQL 2005 and SP2.

Backed up existing SQL 2000 databases and restored on SQL 2005.

Went to Configuration tool and then to the Database setup. Connected to SQL 2005.

Clicked on the Upgrade button. The upgrade fails and I always get the following errors:

"The database version (C.0.6.54) does not match your reporting services installation. You must upgrade your Reporting services database"

Then I get this exception:

System.Data.SqlClient.SqlException: Cannot find the user 'RSExecRole', because it does not exist or you do not have permission.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Microsoft.ReportingServices.Common.DBUtils.ApplyScript(String connectionString, String script)
   at ReportServicesConfigUI.SqlClientTools.SqlTools.ApplyScript(String connectionString, String script)

 

I do not understand why it is looking for user 'RSExecRole', which is a role.

 

Appreciate your help
 

View Replies !   View Related
[380] Unable To Start JobManager Thread
I am intermittently receiving the following error when attempting to start jobs in my sql agent logs, note that no other errors occur in conjunction:

"[380] Unable to start JobManager thread"



My google-fu tells me that this happens when max worker threads has been exceeded, or physical hardware limits have been hit.

I have two questions.

1. Is the best way to go about confirming whether I'm maxing out the number of worker threads (more likely IMO, currently set to 255) or pegging physical resource limits to use the Sql server counters against physical counters in perfmon?

2. My understanding is that if I limit the number of threads available in the offending subsystem (tsql in this case), that this is an acceptable solution because it makes it difficult for concurrent tsql processes to peg the max allowed worker thread threshold. The other solution is to increase the number of max worker threads.

Am I on the right track here? If so, is there any significant danger to bumping max number of worker threads above 255, which I believe is the default?


References:
http://www.sql.ru/forum/actualthread.aspx?tid=173607
http://thedotnet.com/nntp/224118/showpost.aspx
http://www.unixadmintalk.com/f46/380-unable-start-jobmanager-thread-job-appears-sqlagent-log-150378/

View Replies !   View Related
Unable To Start The MS SQLServer Service
Message logged in the SQL Server is

Failed to report the current event. Operating
system error = 31(A device attached to the system is not functioning.).

The OS has been Shutdown and Restarted again but I am not able to start the SQL Server thereafter.

Kindly Suggest

View Replies !   View Related
Unable To Start Sql Debug Session
Hi,

I get this error message each time i try to run the vb application in visual studio .net environment.
--------------------------------------------------------------------------------
"Unable to start SQL debug session. Ensure sqldbreg2.exe and proxy/stub DLL sqldbg.dll are registered on this machine"
-------------------------------------------------------------------------------

I am running visual studio and sql server 2000 on the same machine. I have given permission to sqldebugger user to access the system32 folder and sql debugging folder. This error message is followed by

-------------------------------------------------------------------------------
Attaching the T Sql debugger to process[proj1.exe] on machine 'my machine name' failed Error code 0x80004004
------------------------------------------------------------------------------

I am running MS SQL Server 2000 on windows 2000 adv server.

what can be done to remove this error. Thaks in advance

Sivaraj.

View Replies !   View Related
Unable To Start MS Analysis Service
Hi Gurus,

I have installed MS analysis service(OLAP) on my lap top

my user is in the Administrative group , other than that I tried creating a user with 'OLAP ADMINISTRATOR' privilate and tried to start the ms analysis service

I am getting the error , unable to start the service on server(), you are not a member of OLAP Administrators group

I tried to install the service pack 3 from Microsoft

Could you pleae guide me to start this serivice
Thanks,

View Replies !   View Related

Copyright © 2005-08 www.BigResource.com, All rights reserved