.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

SQL Server 2008: unable to grant server roles

Posted By:      Posted Date: September 22, 2010    Points: 0   Category :Sql Server

SQL Server 2008 Enterprise (10.0.2531.0) installed on SQL Server 2003 R2 SP2.

I am logged in as sa and I try to grant sysadmin (or any server role) to a new account (either windows or sql authentication) and it fails without an error. If I use the gui in the management studio it says okay but when you check the role is not granted. If I use t-sql command (sp_addsrvrolemember) it doesn't generate an error but again nothing happens. The role is not granted.


View Complete Post

More Related Resource Links

Unable to install SQL Server 2008 Express R2 after installing .NET 4.0

Hi experts, I intend to redistribute SQL Server 2008 Express R2 in my installer. I've extracted the setup files from SQLEXPR32_x86.exe and pass in the appropriate command line parameters during the setup. Recently, I noticed if I applied the following Windows Update: .NET 4.0 Client Profile, I will hit into the following error when I installed SQL express. .NET Runtime 4.0 Error Reporting EventType clr20r3, P1 setup100.exe, P2 10.50.1600.1, P3 4bb67524, P4 mscorlib, P5, P6 4ba1da6f, P7 44f0, P8 32, P9 system.security.security, P10 NIL. .NET Runtime Application: setup100.exe Framework Version: v4.0.30319 Description: The process was terminated due to an unhandled exception. Exception Info: System.Security.SecurityException Stack: at Microsoft.SqlServer.Chainer.Setup.Setup.DebugBreak() at Microsoft.SqlServer.Chainer.Setup.Setup.Main() Running the setup.exe from a file server will give these errors but if I copied the entire setup files to a local folder and run setup.exe from there, it runs fine. May I know what am I missing? I definitely need to support to install SQL express running from a file server location. Thanks, MK  

Unable to create Web Folders in Windows Server 2008 R2

Hi, We are unable to create web folder from a Windows Server 2008 R2 system as we do in Windows XP. The web url cannot be identified. The web url is an oracle repository application built in 32-bit OS and now we need this to be added in Windows Server 2008 R2 machine. Kindly help.  

SQL server 2008 - Unable to tune a query with DTA

We are on:Verison: SQL 2008 [10.0.2531] on windows server 2008. Both are enterprise editions.When I highlight the query and right-click, then select Analyze Query in Database Engine Tuning Advisor, then click "Start Analysis",  I get the following error in the "Message" column of "Progress" tab of DTA: Cannot initialize tuning. [.Net SqlClient Data Provider] If I click on this, it displays this message: "Cannot find either column 'msdb' or the user-defined function or aggregate 'msdb.dbo.fn_DTA_unquote_dbname', or the name is ambiguous. Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count=0, current count=1. (Microsoft SQL Server Error: 4121)Please let me know if you guys have any ideas on this error. Thanks,Sam. 

Unable to connect SQL Server 2008

Hi, I have recently installed a trial copy of SQL Server 2008 from MS web but I am not able to connect to the SQL Database Engine locally using Windows Authentication. Whenever, I tried I got the following error message: "A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)" Just to inform you, I have OS Win7.  And I want to establish local connections only on my laptop.

SSMS 2008 Activity Monitor Activity Monitor is unable to execute queries against server (SQL Server

I get the following error when running SQL Server SSMS 2008 (32-bit) on my (Windows 7 64-bit) workstation against our SQL Server 2005 (32-bit) development server running Windows Server 2003 (32-bit): TITLE: Microsoft SQL Server Management Studio ------------------------------ The Activity Monitor is unable to execute queries against server <my server\instance name>. Activity Monitor for this instance will be placed into a paused state. Use the context menu in the overview pane to resume the Activity Monitor. ------------------------------ ADDITIONAL INFORMATION: Unable to find SQL Server process ID 2256 on server VTX-DEV-01 (Microsoft.SqlServer.Management.ResourceMonitoring)   I can expand the panes and all display data except Overview and Data File I/O. This is true for all instances on that server. The SSMS 2005 Activity Monitor (also on my workstation) works fine when connected to that server. I checked for the registry setting to disable the performance counters on both my machine and the server, and it was not there. I started the Performance Counter DLL Host on my machine, but that made no difference. I can see all Processor counters on the server from my local Performance Monitor. I ran "lodctr /R" on both systems, but that didn't help. The only SQL counters I see on the server (from my workstation) are SQLServer:SSIS Pipeline and SQLServer:SSIS

Unable to start T-SQL debugging SQL Server 2008

I'm getting exactly the same problem described here: http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/dcc851e7-35d7-492a-b15c-7dffe47110ed --------------------------- Microsoft SQL Server Management Studio --------------------------- Unable to start T-SQL Debugging. Could not attach to SQL Server process on 'myserver'. Click Help for more information. --------------------------- OK   Help   --------------------------- I've followed advice with regards to Windows Firewall, however it's disabled on both client and server.  I've tried using a SQL Server account but haven't had any more success.  I've also checked the windows event logs on both the client and the server and can't find anything.. Lastly (not sure if this is useful or not) I tried attaching to the Ssms.exe process from Visual Studio 2008 and I get the following output when I try debugging:  ... C:\WINDOWS\assembly\GAC_MSIL\Microsoft.VisualStudio.CommonIDE\\Microsoft.VisualStudio.CommonIDE.dll: Cannot find or open the PDB file. C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Microsoft.DataWarehouse.VsIntegration.dll: Cannot find or open the PDB file. 'Ssms.exe': Loaded 'C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\SQLDE.dll' First-chance exception at 0x7c812a6b in Ssms.exe: 0

SSRS 2008 - report manager: System.Net.WebException: Unable to connect to the remote server

I have an instance of Reporting Services 2008 running on Windows 2003 server.  So, the webservice URL is running on port 801, and runs fine (I can browse reports from that directory, and upload / deploy new reports and overwrite existing reports. Report manager is set to use port 800 (IIS is also on that machine running port 80).  When I attempt to connect to report manager, I get the following error, with a link to "Home" in report manager (which brings me back to the existing error page):    Unable to connect to the remote server  In the logfiles for reporting services, the following error is there: " System.Net.WebException: Unable to connect to the remote server ---> System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it.   Any ideas? Windows Firewall is NOT running on this machine.   Thanks, Chrisrjp

Unable to install SQL Server 2008

HI, I am uable to install SQL SERVER 2008 in my machine. The setup checks in the pre requisites and it fails for a server reboot. It prompts me to reboot the machine. I have already rebooted my machine thrice but still its prompting me for a reboot. Can anyone guide me through this?     Regadrds, Shannid

sql 2008: the activity monitor is unable to execute queries against server

Installed sql server 2008 entrprise edition on VM server windows 2008 (64bit). When launch Activity Monitor, get:

The Acityvity Monitor is unable to execute queries against server <server name>.
Activity Monitor for this instance will be placed into a paused state.
Use the context menu in the overview pane to resume the Activity Monitor.

Additional information:
   Unable to find SQL Server process ID xxxx on server <server name>

Tried to "use he context menu in the overview pane to resume the Activity Monitor" and got the same error again.

Installed sql 2008 in my XP machine, I can use Activity Monitor (AM) for local instance but cannot launch it for the instance on the server (same error).

Used windows authentication with sysadmin role for connection from my machine. On the server used domain\administrator that the account created the instance.

Please help.

Unable to connect Excel 2003 from linked server in sql 2008 64 bit


I was unable to connect to excel 2003 with linked server created in sql server 2008 64 bit. This was working fine with sql server 2005 32 bit.

I know that there no 64 bit drivers for JET drivers, but i am looking for some alternative ways to do the same job.

I dont want to migrate to Excel 2007.

Thanks in advance for all your help.


Unable to change autogrowth properties of SQL Server 2008 data and log files


I have used the GUI and the CLI to attempt to change SQL Server 2008 log file autogrowth property all to NO avail. In other words, there are NO error messages of any kind, indeed the CLI reports that the command completed successfully. But re-examining the database properties shows that NO change was effected.

For the CLI command, I have used the following with dots filled in for my database and logfile:


Why doesn't this work? How to make it work?


SSRS 2008 SP1 Unable to get cataloge items from server.


When I access the report server locally I can access the report builder 1.0 click-once application without problems and it is able to show me a list of the reports.  When I access the same report server via our load balancer that does SSL off-loading I get the error message "Unable to get cataloge items from server." the details of which are below:

An existing connection was forcibly closed by the remote host
Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.
The underlying connection was closed: A connection that was expected to be kept alive was closed by the server.

I had to enable basic authentication and allow anonymous access to the report builder so my client could access it from their computers on their domain.  They have accounts on my domain which they are prompted for and enables them to access the reports website and the report builder application.  Its only when they try to open a report with the report builder that they get this error message about being able to get the catalog.

SQL Server 2008 SP1
Windows Server 2008

Any ideas?

Unable to Install SQL Server 2008 R2 64 Bit on clean install of Server 2008 R2 64 Bit Error CLR20r3



I'm trying to install SQL Server 2008 R2 64  on a clean install of Server 2008 R2 64 Bit. Shortly after double clicking on the setup I get a Windows error message saying the installer has stopped working with the details below.

Suggestions welcomed.



Stopped working

Problem signature:

Problem Event Name: CLR20r3

Problem Signature 01: setup100.exe

Problem Signature 02: 10.50.1600.1

Problem Signature 03: 4bb6742c

Problem Signature 04: Microsoft.SqlServer.Chainer.Setup

Problem Signature 05:

Problem Signature 06: 4bb6742c

Problem Signature 07: 4

Problem Signature 08: 5

Problem Signature 09: System.BadImageFormatException

OS Version: 6.1.7600.

Locale ID: 3081

Read our privacy statement online:


Unable to install SQL Server 2008 SP2 Via PCU Source



I have extracted SP2 to D:\SQL2K8\PCU but I'm unable to install SQL 2k8 SP2 via PCU SOurce and getting the following error "The required attribute 'Path' is missing." D:\SQL2k8\setup.exe /PCUSource=d:\SQL2K8\PCU

2010-10-28 08:36:03 Slp: Sco: Attempting to create base registry key HKEY_LOCAL_MACHINE, machine
2010-10-28 08:36:03 Slp: Sco: Attempting to open registry subkey Software\Microsoft\Microsoft SQL Server\100\Bootstrap
2010-10-28 08:36:03 Slp: Sco: Attempting to get registry value BootstrapDir
2010-10-28 08:36:03 Slp: Reading XML resource 'Microsoft.SQL.Chainer.PackageData.Package.xml'
2010-10-28 08:36:03 Slp: Reading schema resource 'Microsoft.SQL.Chainer.Package.Package.xsd'
2010-10-28 08:36:03 Slp: Error: Action "InitializeMsiExtension" threw an exception during execution.
2010-10-28 08:36:03 Slp: Microsoft.SqlServer.Setup.Chainer.Workflow.ActionExecutionException: The required attribute 'Path' is missing. ---> Microsoft.SqlServer.Chainer.Infrastructure.ChainerInfrastructureException: The required attribute 'Path' is missing. ---> System.Xml.Schema.XmlSchemaValidationException: The required attribute 'Path' is missing.
2010-10-28 08:36:03 Slp:    at System.Xml.Schema.XmlSchemaValidator.SendValidationEvent(XmlSchemaValidationException e, XmlSeverityType severit

Unable to upgrade from SQL Server 2005 to SQL Server 2008 due to Reporting Server check failure

Hi all,

We were trying to upgrade our SQL Server 2005 tp SQL Server 2008, and bumped into some problem with the reporting server check.

Here were the environmental details:
- Windows Vista SP2 32-bit
- SQL Server 2005 (v 9.0.3077)
- Microsoft SQL Server 2008 Upgrade Advisor v 10.00.1600.22

While performing the Microsoft SQL Server Upgrade Advisor, it reported these problems on the Reporting Service:
PreUpgrade "The system cannot find the file specified." RSVDIRSEXIST
PreUpgrade "The system cannot find the file specified." RSIPADDRESSRESTRICTIONS
PreUpgrade "The system cannot find the file specified." RSCLIENTCERTIFICATES
PreUpgrade "The system cannot find the file specified." RSUSESIIS5
PreUpgrade "The system cannot find the file specified." RSIIS7BACKCOMPAT

Unable to attach database in sql server 2008




I have Windows Vista Home Premium and the 180 day evaluation version of SQL Server 2008 installed.

I am getting the following error when trying to attach the AdventureWorks2008 database. I was able to attach the Northwind:

TITLE: Microsoft SQL Server Management Studio

Attach database failed for Server 'HOME-PC'.  (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.1600.22+((SQL_PreRelease).080709-1414+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476


An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)


FILESTREAM feature is disabled.
A file activation error occurred. The physical file name 'C:\Program Files\Microsoft SQL Server\MSSQL10.M

Unable to extract SQL Server 2008 SP1 Cumulative Update 2 executable.



Requested the SQL Server 2008 SP1 CU2 hotfix and got an email with the location (see below) and password.

KB Article Number(s): 960616, 961106, 961760, 961811, 963061, 965217, 967206, 967337, 967561, 967983, 967984, 968085, 968290, 968449, 968834, 968900, 969007, 969131, 969235, 969362, 969469, 969588, 969775, 969872, 970070, 970184, 970198, 970255, 970315, 970461, 970550
Language: All (Global)
Platform: x64
Location: (http://hotfixv4.microsoft.com/SQL%20Server%202008/sp1/SQL_Server_2008_SP1_Cumulative_Update_2/10.00.2714.00/free/381569_intl_x64_zip.exe)

Ran the executable  381569_intl_x64_zip.exe and get prompted for the password.    Doesn't accept the password supplied in the same email.    No error, just nothing happens and nothing is extracted.

Password is 6 characters long and starts with a pound sign (#).

Trying the download again after a second request.    Noticed the password is the same.

Any ideas?


ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend