Everything seems right, but it still gives you access. For whatever reason, SQL Reporting Services needs to have Administrative permissions when running. How to fix this problem:
First Click Start -> Next right click your browser (IE, Firefox, Chrome) -> Run as administrator
Click yes
At this point, navigate or type the address in for the SQL Reporting Services. The page should load now.
Source: Link
Showing posts with label Microsoft SQL Server 2008 R2. Show all posts
Showing posts with label Microsoft SQL Server 2008 R2. Show all posts
Monday, March 12, 2012
Wednesday, February 29, 2012
I Can't Remember the Password to SQL Server User Account
I took over an instance of a Microsoft SQL Server 2008 and the login information I was given wasn't working. Here is how to promote your domain user account to a dba sysadmin.
First you need to stop all the services for each instance. I wrote here how to restart them. Just stop them instead of restarting them.
Right click the service and click Properties
Click the Advanced Tab
Locate the properties box
Scroll down to Startup parameters
Move to the end of the text that is already entered. With no spaces enter ;-m
Click Ok and start the service
This starts the service in single-user mode.
With a domain admin account, launch a command window and type sqlcmd and press enter.
You will see a > Type the following:
Open SQL Server Management Studio and use Windows Authentication
At this point you should be able to now login with that user account.
Go back and stop the service, remove the ;-m and start the service again.
Source: Link
This was successfully tested in SQL Server 2008
First you need to stop all the services for each instance. I wrote here how to restart them. Just stop them instead of restarting them.
Right click the service and click Properties
Click the Advanced Tab
Locate the properties box
Scroll down to Startup parameters
Move to the end of the text that is already entered. With no spaces enter ;-m
Click Ok and start the service
This starts the service in single-user mode.
With a domain admin account, launch a command window and type sqlcmd and press enter.
You will see a > Type the following:
EXEC sp_addsrvrolemember 'domain\user', 'sysadmin'; Hit enter.NOTE: Domain would your domain IE: abc.com and user would be jsmith.
GO Hit Enter
Type Exit, Hit Enter
Open SQL Server Management Studio and use Windows Authentication
At this point you should be able to now login with that user account.
Go back and stop the service, remove the ;-m and start the service again.
Source: Link
This was successfully tested in SQL Server 2008
Friday, December 23, 2011
How to enable Remote connections for Microsoft SQL Server 2008
So I found a great article that explains how to do this. I'll briefly explain it and link to the post below.
Navigating to Start -> All Programs -> Microsoft SQL Server 2008 R2 -> Configuration Tools -> Sql Server Configuration Manager.
On the left hand side you will see SQL Server Network Configuration. Click the + and then select Protocols for (Your instance name). On the right hand side, click TCP/IP and change it to enable -> Yes. It will then ask you to restart your SQL Instance.
Here's how to do that. How to restart Microsoft SQL Server 2008 Service
If you've done all that and your instance isn't showing up? Here's how to fix that. Why can't I find the Microsoft SQL 2008 install I just installed?
Source: Link
Navigating to Start -> All Programs -> Microsoft SQL Server 2008 R2 -> Configuration Tools -> Sql Server Configuration Manager.
On the left hand side you will see SQL Server Network Configuration. Click the + and then select Protocols for (Your instance name). On the right hand side, click TCP/IP and change it to enable -> Yes. It will then ask you to restart your SQL Instance.
Here's how to do that. How to restart Microsoft SQL Server 2008 Service
If you've done all that and your instance isn't showing up? Here's how to fix that. Why can't I find the Microsoft SQL 2008 install I just installed?
Source: Link
How to restart Microsoft SQL Server 2008 Service
After changing specific settings in SQL Server 2008, it asks you to restart the service. Well using the normal services.msc application isn't the right place to be restarting it. You will find the correct one under the SQL Configuration Manager.
You can do this by navigating to Start -> All Programs -> Microsoft SQL Server 2008 R2 -> Configuration Tools -> Sql Server Configuration Manager.
On the left hand side you will see SQL Server Services. Click that and on the right hand side you will now see SQL Server (Your Instance Name). Right Click -> Restart
On the left hand side you will see SQL Server Services. Click that and on the right hand side you will now see SQL Server (Your Instance Name). Right Click -> Restart
You have successfully restarted the SQL Service.
Source: Link
Why can't I find the Microsoft SQL 2008 install I just installed?
I found that it wouldn't show up until I went in and enabled the SQL Server Browser. It was disabled by default.
You can do this by navigating to Start -> All Programs -> Microsoft SQL Server 2008 R2 -> Configuration Tools -> Sql Server Configuration Manager.
On the left hand side you will see SQL Server Services. Click that and on the right hand side you will now see SQL Server Browser. Right Click -> Properties -> Advanced. Change it from Advanced to Automatic.
Refresh Microsoft SQL Server Management Studio or the Application you are trying to connect to. It should now be listed.
Source: Link
You can do this by navigating to Start -> All Programs -> Microsoft SQL Server 2008 R2 -> Configuration Tools -> Sql Server Configuration Manager.
On the left hand side you will see SQL Server Services. Click that and on the right hand side you will now see SQL Server Browser. Right Click -> Properties -> Advanced. Change it from Advanced to Automatic.
Refresh Microsoft SQL Server Management Studio or the Application you are trying to connect to. It should now be listed.
Source: Link
Thursday, December 22, 2011
Microsoft SQL Server 2008 R2 Fails when installed
I am trying to install MS SQL Server 2k8 R2 and keeps throwing an access denied error. It gets hung up on sqlenginedbstartconfigaction_install_configrc_Cpu64.
OS: Windows Server 2008 R2 SP1
User: Domain Admin
It looks like the DISA STIG that was applied was causing the issue. The local administrator account seems to be needed. I turned off all GPO settings for the computer and it installed.
Here is what I used to help me troubleshoot the issue. Link
OS: Windows Server 2008 R2 SP1
User: Domain Admin
It looks like the DISA STIG that was applied was causing the issue. The local administrator account seems to be needed. I turned off all GPO settings for the computer and it installed.
Here is what I used to help me troubleshoot the issue. Link
Subscribe to:
Posts (Atom)