0
votes
0answers
17 views

SQL DATABASE USING VPN

I have a very simple classic asp site on a Windows 2008 Server with an IIS 7.5 that connects to an Sql database on a Sql 2008 r2. the site works perfectly when accessing it both locally from the ...
1
vote
1answer
84 views

sql server 2008 express, how login as admin

I am pretty newbie on sqlserver. I just want to logon by Management Studio on a sqlserver just for backup a db. But it seems that I haven't enough permissions because I am guest. Anyone could explain ...
0
votes
2answers
573 views

In sql-server, how do I give server-level permission to user to make backups on any database

I need to give a user server-level permissions, once and for all time, to back-up any existing or future database on the server instance, without making the user sysadmin. How can I do that? I've ...
0
votes
1answer
414 views

Package run on SQL Server Job Agent - Login failed for user

I created a package on my SQL Server (2012) through the import/export data wizard which exports data to another SQL Server (2008). I set up a job which runs this package but I get an error: ...
0
votes
1answer
160 views

Create Report in Microsoft Excel - Permissions Issue in Team Foundation Server 2010

I am trying to use the feature "Create a Report in Microsoft Excel" for Visual Studio TFS 2010. I am being prompted for a username and password in Excel for any given Team Project when right clicking ...
4
votes
2answers
846 views

MS SQL access to restored database without sysadmin role

I have databases from different projects on one server. I can't give all developers administrative (sysadmin) access to the databases. They have to have the permissions needed to create and restore ...
3
votes
2answers
1k views

Can't Connect w/ SQL Management Studio After Domain Change

Our old Small Business Server 2003 (acting as our domain controller) was on the fritz, so we replaced it with a new Windows Server 2008 box and set the server up as our new domain controller. In ...
0
votes
3answers
2k views

SQL Server 2008: Getting Login failed for user “Domain\User”. Failed to open the explicitly specified database [CLIENT: IP.ADD.RR.ESS]

This is a very similar issue to " SQL Server 2008 login problem with ASP.NET application: Failed to open the explicitly specified database " which unfortunately seems to have gone unsolved. My issue ...
1
vote
1answer
289 views

Setting Local Policy not working?

What could I be doing wrong here? Added Everyone to local security settings (testing purposes only) Forced the policy to update with gpupdate /force ran whoami /priv The permission I added is ...
2
votes
1answer
1k views

What is the default account/group for SQL 2008 R2 cluster permissions and can you create/add them?

Last night we had an issue where the permissions were altered a SQL 2008 R2 Cluster Instance, such that the instance could no longer access the shared drives where the system databases were installed. ...
1
vote
1answer
6k views

CREATE DATABASE permission denied in database 'master' … A database with the same name exists, or specified file

Background: I'm trying to get the Live Demos of Telerik's Rad Controls for ASP.NET AJAX working on my local machine in IIS 7. I'm getting an error when I view the ComboBox demo. Error I get: ...
0
votes
2answers
1k views

How to enable a SQL Server 2008 login to access a directory on another server

I need a sql server login (not a windows login) to be able to perform bulk inserts using a file on another server. using bulk insert \\path\to\server\c$\path\to\dir does not work because of ...
1
vote
2answers
2k views

Accessing SQL Server Reporting Services by Non-Admin Accounts

When accessing SQL Reporting Services Report Manager through Great Plains 2010, we're getting the following: An error has occurred during report processing. (rsProcessingAborted) Get Online Help ...
1
vote
1answer
525 views

Help with SQL Server 2008 permissions

Today I migrated a database from SQL Server 2005 to SQL Server 2008 R2 using the backup/restore method which went fine and did not generate any errors. I can log into SQL Server 2008 through the SQL ...
2
votes
4answers
11k views

The database myDb is not accessible. (ObjectExplorer)

I'm developing an ASP.NET MVC3 web app, which connects to a SQL Server 2008 R2 database. Everything was working fine, until I started getting this error: The database myDb is not accessible. ...
0
votes
1answer
42 views

Setting up individual accounts to a SQL Server

I am attempting to setup a MS 2008 sql server that would allow many users access to there own private databases. I would like the adventure works databases installed on all of these as well. My ...
2
votes
1answer
367 views

What permissions does SSMS Intellisense rely on?

We have a server on which SQL Server 2008 is running. When we connect to it with SSMS with some logins (from SSMS 2008), Intellisense is available. For others it isn't. The logins in question connect ...
0
votes
1answer
528 views

SQL 2008. How to let user to create/alter sprocs in only one particular schema?

I have a user which can read and write but now he needs to be able to create/alter a sproc but giving him ddl_admin will make it too unsecure. I dont trust him that much. What can I do about it? Can ...
0
votes
2answers
4k views

How can I grant read-only access to my SQL Server 2008 database?

I'm trying to grant read-only access (in other words: select queries only) to a user account on my SQL Server 2008 R2 database. Which rights do I have to grant to the user to make this work? I've ...
9
votes
1answer
16k views

What can user do with VIEW SERVER STATE permissions?

In SQL Server 2008 there is a permissions VIEW SERVER STATE. What rights this permission give to user? What SQL Server mean by SERVER STATE?
0
votes
1answer
149 views

Permissions issue with SQL Server 2008 Express

I think this falls into the category of 'never ask a developer to do a server administrator's job'. I'm a developer writing a couple of ASP.NET MVC 2 sites. I've attempted to use the ASP.NET ...
10
votes
2answers
19k views

“'' is not a valid login or you do not have permission” on sql server installation

I have tried installing SQL Server 2008 multiple times on my machine, and I always receive this error about 3/4 of the way through: '' is not a valid login or you do not have permission. I use SYSTEM ...
1
vote
5answers
6k views

Automate SQL Server 2008 backup script failing to run

I have created a maintenance plan but when I try to execute I get the error: Message [298] SQLServer Error: 15404, Could not obtain information about Windows NT group/user 'XX\Administrator', error ...
1
vote
2answers
632 views

Deny Stored Procedure Data Modification by User Security

I want an easy way to make a read-only user on my database. The user should have permission to execute stored procedures only if they don't modify data. I don't want to figure out which stored ...
0
votes
2answers
1k views

Only allow ability to read the views for a particular SQL Server user over ODBC

Newbie question: I have a designer who reads information from a SQL Server [2008] database. I've setup a few views for him to pull his data from and granted his user a member of the db_dataread ...
2
votes
3answers
780 views

How can I tell what user account is being used to perform an action (in context of SQL Server)?

For example, when installing SQL Server 2008, I had to pick an account for the database engine to run as. When I went to attach a 2005 database file with SQL Server Management Studio, there was a ...
1
vote
2answers
7k views

Can't connect to local database in SQL Server (2008) Management Studio

An IT guy at work remoted into and installed SQL Server 2008 Developer on my terminal, and at first everything seemed to be set up correctly. However, when I go into the Management Studio, I can't ...