Permission Issues In SQL Server 2005
Sep 21, 2007
We resent installed SQL Server 2005 and I am very new to It. Here is what I have done.
Created a new user in SQL server and denied everything for a particular table to that user so that a select * from that table will result in a permissions error. Also that user cannot view the table in SQL manager
The problem now is that that user can create a stored procedure that has the SQL statement Select * from that table and execute the stored procedure to view the table. The reason I created this user is to allow a team in the company to create stored procedures for Crystal. In theory he should be able to create stored procedures but not get any data from the denied tables. How can I achieve this?
Regards,
View 1 Replies
ADVERTISEMENT
Jan 6, 2007
Can u guys help me out here?
I cannot connect to database from localhost. If i type http://localhost/mobile/default.aspx it will show SELECT permission denied on object 'KATEGORI', database 'mobile', schema 'dbo'.
I try giving permission to ASPNET account and also IIS account to the database 'mobile' but nothing works. But if i give permission to IIS using integrated windows authentication it works in localhost but not when i use ip address example : 202.189.176.145:10334/mobile/default.aspx. It will prompt username, password and domain i think. How can i configure sql server to give permission for iis ?
View 2 Replies
View Related
Oct 16, 2007
I originally installed SQL Server Express 2005 on my computer using Windows Authentication mode, and discovered when I tried to add another user/login that I didn't have permission to do so. This is rather odd as the windows account that I installed SQL server with is the system admin for the computer.
I have successfully changed the login mode to mixed, and have tried to login in as "sa", but it appears that "sa" was given some sort of password (did SQL server automatically generate one?), and I don't know what it is. When I go into command prompt and try to change the password, it says that it cannot alter the login 'sa' because it does not exist or I do not have permission (i'm pretty sure it's the later, as 'sa' shows up on the list of logins in SQL server express).
I'm so stuck! Please help!
View 6 Replies
View Related
Oct 2, 2007
Hello!
I'm having trouble doing a basic permission, I need to prevent one user from seeing one column in a view, such as a students phone number. However, when I deny the user from seeing the column it denys the user from viewing the entire view. Can someone tell me the correct way to deny the user from just the one column.
Thanks in advance
Chris
View 2 Replies
View Related
Nov 17, 2005
We have a web app that accesses Sql Server 2000 using windows authentication. We recently installed SQL Server 2005 on a new server and are in the process of porting the data from SS2000 over to 2005. I expected some problems, but I've run into something that seems like it should be relatively simple to solve, yet I have been banging my head against the wall for a couple of days. After changing the connection string in web.config of the web app to point to the new SQL Server 2005 database, I keep getting ... SELECT permission denied on object 'tUser', database 'GDoc', schema 'dbo'. The problem is, when I go into Management Studio and check the permissions, the user I'm logged in as DOES have select permissions on that database. What am I not doing? Am I forgetting something simple?
View 4 Replies
View Related
Dec 13, 2005
I have an application that uses Integrated Windows authentication. My Web.config looks like below
<add key="dbconnection" value=" server=XXX;Initial Catalog=XXX;persist security info=False;Integrated Security=SSPI;Pooling=true" />
When users try to access my application, they get the below error:
Execute permission denied on object 'SprocName', database 'DBNAME',Owner,'dbo'
The Only way I could get rid off the error is if I set DBO permissions for the user group on the databse.
Can someone suggest how to set up a security group with the ‘necessary’ permissions on SQL SERVER (ie read,write execute Sproc etc) and not too many extra ones, like DBO.
Thanks,
View 2 Replies
View Related
Apr 20, 2006
I have a stored procedure in my asp.net 2.0 app that will not run. I am using an sqlcommand object and executenonquery. At first I received an error "execute permission denied". I had already given the user on sql server read and write permissions. So -- since I was not passing the sql server userloginid or password in the connection string, I tried changing the connection string in my web.config to:
"data source=xxxSQL2005;initial catalog=AdventureWorks; User Id=myid;password=mypasswd"
now I get an error that the login has failed for user xxx. So I am wondering what I need to do to run stored procedure in a web app. I am using the full sql server version not express.
Thanks for any help on this.
smHaig
View 1 Replies
View Related
Jul 18, 2007
I am trying to install SQL2005 Developer Edition on Vista. I can not get the Server Database and Workstation components to install.
I have uninstalled all the SQL stuff trying to get them install. Disabled and enabled UAC.
The User rick is an administrator, both on the domain and the local computer.
I get a modify permissions error on C:Windowssystem32SQLAGENTCTR90.DLL
and on some registry entries, if I ignore the first error, either way it doesn't finish installing everything.
Here is what looks like the relevant portion of the ServerDatabase services log file.
Configuring ACL:
Object: C:Windowssystem32SQLAGENTCTR90.DLL
ACL: (A;OICI;0x1200a9;;;LU)(A;OICI;0x1200a9;;;MU)
Action: 0x100
Succeeded.
Configuring ACL:
Object: C:Windowssystem32SQLAGENTCTR90.DLL
ACL: (A;OICI;0x1200a9;;;[SQLServer2005SQLAgentUser$RICKSVISTA$MSSQLSERVER])
Action: 0x100
Failed ACL:
ReplaceSDDLSid is failed at the error code 1332; Converted SDDL: '(A;OICI;0x1200a9;;;[SQLServer2005SQLAgentUser$RICKSVISTA$MSSQLSERVER])'
Error Code: 0x80077342 (29506)
Windows Error Text: Source File Name: sqlcasqlsddlca.cpp
Compiler Timestamp: Tue Sep 13 01:08:29 2005
Function Name: ExceptionInSDDL
Source Line Number: 65
---- Context -----------------------------------------------
Setting status of unmanaged components and removing unmanaged resources
Error Code: 29506
MSI (s) (20:FC) [09:07:19:951]: Leaked MSIHANDLE (15949) of type 790531 for thread 1116
MSI (s) (20:FC) [09:07:19:951]: Leaked MSIHANDLE (15835) of type 790531 for thread 1116
MSI (s) (20:FC) [09:07:19:951]: Note: 1: 2769 2: Do_sqlFileSDDL.D20239D7_E87C_40C9_9837_E70B8D4882C2 3: 2
MSI (s) (20:28) [09:07:19:998]: I/O on thread 2876 could not be cancelled. Error: 1168
MSI (s) (20:28) [09:07:19:998]: I/O on thread 3704 could not be cancelled. Error: 1168
MSI (s) (20:28) [09:07:19:998]: I/O on thread 172 could not be cancelled. Error: 1168
MSI (s) (20:28) [09:07:19:998]: I/O on thread 1360 could not be cancelled. Error: 1168
MSI (s) (20:28) [09:07:19:998]: I/O on thread 1908 could not be cancelled. Error: 1168
MSI (s) (20:28) [09:07:19:998]: I/O on thread 3180 could not be cancelled. Error: 1168
MSI (s) (20:28) [09:07:19:998]: I/O on thread 3836 could not be cancelled. Error: 1168
MSI (s) (20:28) [09:07:19:998]: I/O on thread 2784 could not be cancelled. Error: 1168
MSI (c) (7C:58) [09:07:19:951]: Disallowing shutdown. Shutdown counter: 0
Error 29506. SQL Server Setup failed to modify security permissions on file C:Windowssystem32SQLAGENTCTR90.DLL for user Rick. To proceed, verify that the account and domain running SQL Server Setup exist, that the account running SQL Server Setup has administrator privileges, and that exists on the destination drive.
MSI (s) (20!5C) [09:07:19:998]: Product: Microsoft SQL Server 2005 -- Error 29506. SQL Server Setup failed to modify security permissions on file C:Windowssystem32SQLAGENTCTR90.DLL for user Rick. To proceed, verify that the account and domain running SQL Server Setup exist, that the account running SQL Server Setup has administrator privileges, and that exists on the destination drive.
MSI (s) (20:74) [09:07:20:014]: Executing op: ActionStart(Name=Rollback_SetServerSSNLDefaults.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Setting Client Network Default Settings,)
Info 2769.The installer has encountered an unexpected error. The error code is 2769. Custom Action Do_sqlFileSDDL.D20239D7_E87C_40C9_9837_E70B8D4882C2 did not close 2 MSIHANDLEs.
MSI (s) (20:74) [09:07:20:045]: Executing op: CustomActionSchedule(Action=Rollback_SetServerSSNLDefaults.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1345,Source=BinaryData,Target=Rollback_SetServerSSNLDefaults,CustomActionData=010Setting Client Network Default Settings10000MSSQLSERVERMSSQL.1MSSQL.111)
View 1 Replies
View Related
Sep 27, 2007
Hi there
We have 1 database that using SQL2005 and as Domain Admin I couldn't get access to one of the VIEW. But some other guys (not sure which group he is on as yet) can access no problem.
So I've setup my login as dbo of that database and still I couldn't get access to SELECT.
Any ideas?
Thanks
View 2 Replies
View Related
May 8, 2006
I am having trouble getting SQL Reporting Services 2005 to work.
When I go to: http://localhost/reportserver
I get this . . .
Reporting Services Error
The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError)
Access to the path 'C:Program FilesMicrosoft SQL ServerMSSQL.3Reporting ServicesReportServerRSReportServer.config' is denied.
I then went to, "Configure Report Services Configuration" and I see . . .
Web Service Identity
ASP .NET Service Account (blank)
I suspect it needs an ASP .NET Service Account, but I can't fill it in.
Clearly, this is an IIS issue. I am running Win2K SP4 with IIS 5.0. I can run ASP.NET pages that access ADO.NET databases, so something is working.
I'm not too sure where to look next.I suspect I should look in IIS directory security.
I ran the "Permissions Wizard" and now I'm a little closer,
The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable) Get Online Help
Login failed for user 'TEST-SERVERASPNET'.
What am I doing wrong?
View 2 Replies
View Related
Mar 24, 2006
VS.NET 2005 automatically deploys a CLR stored procedure when you start a project with debugging. However, if the CLR stored procedure attempts to access external resources you will get a message stating:
System.Security.SecurityException: Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
I've isolated this to being because the CLR stored procedure does not have the EXTERNAL_ACCESS permission set.
Is there a security attribute that can be used to decorate the CLR stored procedure code so that VS.NET 2005 will register the CLR stored procedure with the correct permission set?
Steve Miller
View 18 Replies
View Related
Dec 13, 2007
Hi,
I am learning SQL on my own computer and I am having difficult creating a new DataBase. I am using SQL Server Manabgement Studio Express. I installed it as an administrator; however, the software states that I do not have the proper permission. When I attempt to create a new DB, I get a message stating
TITLE: Microsoft SQL Server Management Studio Express
------------------------------
Create failed for Database 'test'. (Microsoft.SqlServer.Express.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Database&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)
------------------------------
CREATE DATABASE permission denied in database 'master'. (Microsoft SQL Server, Error: 262)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=262&LinkId=20476
how do I correct this issue?
View 1 Replies
View Related
Jul 20, 2006
In SQL 2000, a guest user can access any system tables in a database, but it looks not the same in SQL 2005. What even worse is the SQL security handles it in a confused way. When I sign on as sa and run:
SELECT * FROM sys.sysreferences
Of course I get what I want. While, if I sign on as a user only has guest privilege, I get nothing. Based on my understanding, if one does not have permission to SELECT, he should get rejucted error message. Otherwise, he should get return data. Now, SQL 2005 does not give any.
More interesting thing is when select * from sys.sysobjects, SQL 2005 return data to both sa user and user with guest privilege. Did MS applied different security on different sys.sys.. table? When a select return nothing, how can we know if there is no data at all, or the user does not have sufficient privilege.
Please help me to get out this puzzle.
Thanks.
View 1 Replies
View Related
Sep 19, 2007
SQL Server 2005 anomoly?
In SQL Server Management Studio I granted specific permissions to user "A" to do Select, Insert, Update, Delete on Table "B" -
When I logged on as User "A" and attempted the Insert imto table "B" I got the following error:
"Insert Permission Denied on Table B, Database C, Schema dbo"
Is this a problem with the dbo schema?
Then I went back and created a stored proccedure "D" with the exact same Insert statement inside the procedure. I granted User "A" execute permission on the stored procedure "D".
I then logged on as User A and executed Stored Procedure "D". No Problem - stored procedure executed fine with the Insert.
I attempted the Insert statement again - straight SQL - as User "A" and got the same error as above ("Insert Permission Denied.....")
Strange behavior - cannot do a SQL. Insert even though user has permissions but can execute a store procedure with the same Insert statement.
What gives?
View 2 Replies
View Related
Mar 14, 2007
I am attempting to setup SSL with SQL Server 2005. I do not wish to have the domain account that is running the SQL Server Service be an administrator. What rights/permissions does this account require in order to start sql server with an SSL certificate?
I have tried putting the certificate in the local store but you need to be an admin to see it there. If I put the certificate in SQL Server Service account's personal store, I can't start sql server. "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." Is the error I get.
Thank you for your help.
View 13 Replies
View Related
May 23, 2008
I have a custom made database role that has permissions to execute a stored procedure. The store procedure then selects data from some tables. But the role does not have select permissions on the tables. Do I have to allow select on the tables, or can I do this another way?
View 2 Replies
View Related
May 14, 2008
Hi
I need to add a linked server .I am able to add it using SA account however if i use any other account i am unable to do so.
My question is what permisson does a ordinary user requires to add a linked server .
regards
Hrishy
View 3 Replies
View Related
Apr 19, 2007
Lets say i have a database user usrJohn. I have a set of views i want John to see, but i don't want him to be able to see the query that builds that view, but i want that view to show up in his View list. how can I make that possible?
View 9 Replies
View Related
Aug 18, 2006
I get an error dialog when I try to create a new SQL database, both via the Add New Item dialog and the property wizard of a new SqlDataSource control. The error is:
Local Database File:
User does not have permission to perform this action.
I've searched for help with this.
I ensured the App_Data folder exists and I added the local ASP.NET account to the group that have R/W access to it (although the RO flag is in an unchangeable tri-state on the folder).
The SQL Server Express error log is clean and indicates full functionality.
Everything is running locally.
No VWD installation errors.
Any ideas?
Thank you!
View 3 Replies
View Related
Jan 9, 2007
Hi, I always had the impression to use asp.net membership, in sql server, I needed dbo permission because all its tables and what not always had [dbo] in front of them and "dbo." is all hard coded into their build-in membership classes. In my shared hosting enviornment, I always had to ask my db admin to give me dbo permission explicitly. I saw this article today http://www.aquesthosting.com/HowTo/Sql2005/Providers.aspx and after I followed their direction, by using ec sp_addrolemember 'aspnet_Membership_FullAccess', 'yourUser'
go
Exec sp_addrolemember 'aspnet_Personalization_FullAccess', 'yourUser'
go
Exec sp_addrolemember 'aspnet_Profile_FullAccess', 'yourUser'
go
Exec sp_addrolemember 'aspnet_Roles_FullAccess', 'yourUser'
go
Exec sp_addrolemember 'aspnet_WebEvent_FullAccess', 'yourUser'
got
View 1 Replies
View Related
Aug 30, 2007
Dear,
What minimum permission do i need to grant to a Remote Login to create a linked server.
Regards
Sufian
View 7 Replies
View Related
Mar 16, 2004
Environment: Visual Studio .NET 2003 on pc (Windows XP Pro) in workgroup A, ASP .NET application on server (Server 2000 w/ IIS 5 in workgroup A), SQL Server 2000 on same server (Enterprise Edition)..........all on Intranet with static IP's for all machines.
I have the {servername}VSDevelopers group with sysadmin priveleges on SQL Server.
I have the {servername}ASPNet user with public on SQL Server.
I can create stored procedures in database ABC on SQL Server from Visual Studio on pc(default named to dbo.{stored_procedure_name}).
I can edit same stored procedures in database ABC on SQL Server from Visual Studio.
I get EXECUTE error when trying to run stored procedure via ASP.NET application on server.
I check, and permissions to objects on SQL Server for VSDeveloper group shows as no permissions.
I set the permissions for all user created objects (tables, stored procedures) to "full" for VSDevelopers.
Works..............til I create a new object.
Any ideas? Suggestions? Solutions?
If need more detail, let me know. Thanks.
View 2 Replies
View Related
Jul 26, 2001
Hi,
I'm trying to run the Bulk Insert statement but in order for me the run it, i need to have the sysadmin permission. Can someone show me how to grant sysadmin permission to my SQL Server user? This is really urgent. Thank you in advance.
View 1 Replies
View Related
Feb 13, 2015
How to find the list of logins/users who do not have any permission (except default Public) access.
View 4 Replies
View Related
May 8, 2015
finding all users that have permission to modify stored procedures in SQL SERVER.
View 0 Replies
View Related
Mar 20, 2007
I have just installed sql server 2005 developer edition with ssrs
I am getting following error
When Browsing
http://localhost/ReportServer$Yukon/
Reporting Services Error
--------------------------------------------------------------------------------
The permissions granted to user 'KAMRANSHAHIDIUSR_KAMRANSHAHID' are insufficient for performing this operation. (rsAccessDenied) Get Online Help
--------------------------------------------------------------------------------
SQL Server Reporting Services
**********************************************************************************************************
When editing Surface Area Configuration
TITLE: Surface Area Configuration
------------------------------
System.Web.Services.Protocols.SoapException: The permissions granted to user 'KAMRANSHAHIDIUSR_KAMRANSHAHID' are insufficient for performing this operation. ---> Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'KAMRANSHAHIDIUSR_KAMRANSHAHID' are insufficient for performing this operation.
at Microsoft.ReportingServices.Library.RSService.SetSystemProperties(Property[] properties)
at Microsoft.ReportingServices.WebServer.ReportingService.SetSystemProperties(Property[] Properties)
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.WebServer.ReportingService.SetSystemProperties(Property[] Properties) (System.Web.Services)
------------------------------
BUTTONS:
OK
**********************************************************************************************************
Also When I connect from management studio for the reporting services instance I get the same error of insufficient privilge
TITLE: Microsoft SQL Server Management Studio
------------------------------
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
The permissions granted to user 'KAMRANSHAHIDIUSR_KAMRANSHAHID' are insufficient for performing this operation. (rsAccessDenied) (Report Services SOAP Proxy Source)
For help, click: http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsAccessDenied&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=9.00.1399.00
------------------------------
The permissions granted to user 'KAMRANSHAHIDIUSR_KAMRANSHAHID' are insufficient for performing this operation. (rsAccessDenied) (ReportingServicesLibrary)
For help, click: http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsAccessDenied&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=9.00.1399.00
------------------------------
BUTTONS:
OK
------------------------------
**********************************************************************************************************
What Am I missing ?
But While browsing report {not server } works fine
View 1 Replies
View Related
Feb 4, 2015
How can we deny an Object select Permission which have Sysadmin role.
View 2 Replies
View Related
Jun 2, 2015
I gave a user all required permission to view the SSRS report. User is able to select from the dropdown list but unable to view the data, It is showing a blank screen.
View 9 Replies
View Related
Jul 16, 2015
I was able to build and Preview the report, but ran into an issue when trying to deploy the report that I created. After reviewing various postings on this issue, I still can't seem to get past the issue.
Currently running SQL 2014 Developer Edition, SQL Server Data Tools for VS 2013, and O/S Windows 8.1 all on the laptop. I followed the video and left the default value of LocalHostReportServer. System said LocalhostReport Server could not be found.
I went to SQL Configuration Manager and tried using the Logon as the URL. Still received the same error.
I went to Reporting Services Configuration Manager and used the URL, still received the same error.
View 10 Replies
View Related
Jul 29, 2015
I'm trying to figure out why this SQL Agent job keeps failing.
We used management studio, and connected as mydomainmyuser, and developed a script to take a backup file from a network share and restore it. It worked fine in SSMS under that login.
After we got it working , we created a SQL Agent job on the same server to run the script, and set the agent job to run under that account that we tested with.
This is the error message we got:
"Executed as user: mydomainmyuser. Create Database permission denied in database master'.
So, I gave that login the rights to Create Database and Create Any Database. Then the error message changed to:
"Executed as user: mydomainmyuser. User does not have permission to RESTORE database 'mydatabase'. [SQLSTATE 42000][ERROR 3013] RESTORE DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed. "
* I can't use SA for the job account, because the SA account doesn't have rights to see the network folder where the backup file sits, so it has to run under the domain account.
* The user is a member of the dbcreator role - and the serveradmin and sysadmin roles
* The user is a member of dbowner on the database I am trying to overwrite with the restore
* I have given the user the rights CREATE DATABASE and CREATE ANY DATABASE
The only suspicious thing I found was that it appears the server was renamed at one time. When I looked at the login in management studio, I was not able to change some of the rights. On the Securables page, it shows the server name as "MyServer-New", but the server name is "MyServer". It is a replacement, and I suspect that when they did the replacement they named it "MyServer-New", set everything up, then renamed it.
I found this post listed below, and ran the script (shown below), and it showed that the server name was MyServer and the ServerInstanceName is MyServer-New
[URL] .....
SELECT HOST_NAME() AS 'host_name()',
@@servername AS 'ServerNameInstanceName',
SERVERPROPERTY('servername') AS 'ServerName',
SERVERPROPERTY('machinename') AS 'Windows_Name',
SERVERPROPERTY('ComputerNamePhysicalNetBIOS') AS 'NetBIOS_Name',
SERVERPROPERTY('instanceName') AS 'InstanceName',
SERVERPROPERTY('IsClustered') AS 'IsClustered'
I can't reset SQL until the next maintenance window to test changing the server name as outlined in the post.
Am I on the right track with the name change messing up permissions, or is there something else I need to check?
View 5 Replies
View Related
Jul 13, 2015
The requirements are:
1. the user has read-only permissions to dbo tales.
2. the user can do everything within the rpt schema, which contains all objects analyzing dbo tables.
3. the user does not have any permission outside rpt schema, except permissions in #1.
The current solutions are:
1. grant the user select only on dbo tables.
2. make the user the owner of rpt schema.
3. Grant the user database permission on create table/create procedure/create view/create function.
My question is - in step 3, should I just grant "Alter" database permission to the user? Granting Alter seems to be cleaner and simpler. According to MSDN,
"Alter" confers the ability to change the properties, except ownership, of a particular securable. When granted on a scope, ALTER also bestows the ability to alter, create, or drop any securable that is contained within that scope.
View 2 Replies
View Related
Jan 16, 2007
Edition: SQL Server 2005 Standard
I am trying to take a snapshot of a database for use in a publication. The account under which the snapshot agent is running is set to have the db_owner role for the database and have write access to the snapshot share.
I can not get the snapshot to run unless the account under which the snapshot agent is running is granted the sysadmin fixed server role. Because of the security implications of this, I don't want to grant these permissions.
As far as I am concerned, the minimum requirements for the snapshot account have been met and I have tried every other alternate that I can think of. I've checked MSDN and the newsgroups but I still have not solved the problem.
The error that I get when I run the snapshot.exe from the command line is:
The remote server "TURING" does not exist, or has not been designated as a valid Publisher, or you may not have permission to see available Publishers.
This error message has now inexplicably changed to:
You do not have sufficient permissions to run the command...
Any ideas? Thanks.
View 3 Replies
View Related
May 31, 2007
hello,
What role or system privilege do I need to grant to a user if he need to read the data from a table which is in a link server object? where I can find the document about these commands.
Thanks
View 1 Replies
View Related
