Using A SQL Query To Create A User Account.
I need to be able to have users run a query under the 'sa' account that will create another account that will just be used for reading and writing to a specific database. Is there a way to do this with just a sql script or can you only set up logins and accounts from the enterprise manager?
View Complete Forum Thread with Replies
Related Forum Messages:
How To Create A User Account For My Web Site In SQL Server Management Studio
Hi, I keep getting a connection failed error message... CANNOT the DATABASE " " requested by the Login. The Login failed for User 'NT Authority/ Network Service' error and I figure I should create an account for the site to access the Database with but I do not know how to create an account in SQL server using the Management studio?? Anyone willing to give me the exact information I need to do this so I do not do something else and ruin things please??? I am not much of an SQL DBA. thanks in Advance.
View Replies !
Why RS Lets User To Create BookmarkID And Actions By Using A Different Query That The Reportitem Is Using.
It seems in the spec that Data Regions can only reference a single dataset, then why bookmarkID and bookmark action can reference a different dataset than the one that the Data Region is using? Like in this case: 1) create a table with dataset1 2) create another table with dataset2 3) create a bookmarkID using =Last(somefield, "dataset1") in any table cell in the first table 4) create a bookmark action using =Last(somefield, "dataset1") in any table cell in the SECOND table. This is valid report, and it can preview.... I know this example not practical at all, it is just used to illustrate my question. Is this a scoping rule exception for any special reasons? or it's just a bug? If it is a scoping rule exception, please explain, and a practical example would be great.
View Replies !
How I Create Report That Query Data By Using One Or Two Parameter, Depend On User Choose?
Hi, I have some problem about report parameters. I want to create report that query data by using one or two parameter, depend on user choose. Example, my dataset have 2 parameter is "month" and "year". Select * from table 1 where year(mytime) = @param_year ------ (1) and month(mytime) = @month ------- (2) I want to query only (1) statement when user does not choose "month" parameter. By the other way, if user choose "month" and "year", I want to query by (1) + (2) statement. How can I do it? If not, there are other solution for solving it. Such as separate report ... ? Thank you very much.
View Replies !
Create Second 'sa' Account ('sa2') On SQL 6.5?
On the latest SQL 6.5 with the latest SQL 6.5 service pack, what's thetrick to creating an account besides sa that has the power to createdatabases? I was thinking of calling this account 'sa2'. Why do this?Well, my boss asked me to do it because of a SOX audit + SAS-70 auditkind of thing.I tried using the GUI to do it, but then when using the GUI as sa2, Ifind the "Create Database" has been greyed out.I have a funny feeling that the only way to get this is to hack thesys* tables, which is a little risky.Oh, and trust me, if I had the political weight in my company to getoff SQL 6.5, I would, but I don't. And mgmt already knows that SQL 6.5is past support timeframe and is a ticking timebomb.
View Replies !
How To Create A Sql Svr Account??
Hello , I am using sql svr 2005 ,I cannot deploy my db because local account does not have read rights , so how can I change it or how can I create a sql server account which has every rights (read,write,execute) to the database ?? F16 LĂ?GHTĂ?NĂ?NNNG
View Replies !
Rda - User Account What
Hi! I'm using RDA from my Windows Mobile. On my developer computer I've set up anonymous authentication against my IIS. Now I want to set it up for real. What access should the RdaUser account have that I use in IIS to be able to work correct against the Sql Server 2005? Is User group preveliges ok? In Sql Server 2005 do I need to add the RdaUser to Server Logins and map against my database? /Magnus
View Replies !
Question About User Account
Hi all,I would like to know how I can retrieve the user ID and password from the DB if I have created a new user account using SQL server 2000? I want to create a login page in .aspx page but I am not sure how I can pull out the login info from the DB and then compare with the uesr input? Is that any specific table store the user ID and password by default?I would be very appreciated for any code example in both conditions (window authentication and SQL server authentication). Thanks.
View Replies !
Script As On A SQL User Account...
Has anyone done a "Script as Create to..." on a SQL account then ran the script on another server? I am trying to get a user account onto another se3rver and I don't know the password. I run this command... CREATE LOGIN [testuser] WITH PASSWORD=N'Ÿ÷ úm|qeżPţFü“‹żô*±Q† 097', DEFAULT_DATABASE=[DBEMPTY], DEFAULT_LANGUAGE=[us_english] GO This was generated by doing the "Script as Create.....blah blah blah" but the password is not the same. Is there a process to copy an account from one server to another that will bring the password over with it? Thanks
View Replies !
User Account In Replication
I want to do bidirectional transactional replication on two seperate servers. I have successfully achieved the same on single machine with 2 seperate databases. For seperate servers which user account should I use. thanks
View Replies !
Can Renaming Of User Account On AD Cause This?
Hi, My original account on the AD (Active Directory) was Usr129 and at that time I had installed MSDE on my local box - due to which my "local MSSQLServer" was also called Usr129. Sometime back our LAN administrator renamed the accounts of all users. My new account on the AD (after this renaming) became GBUsr1177. Untill recently, my "local MSSQLServer" also appeared to have easily go through this renaming activity and thus my local installation became GBUsr1177. Recently I started to have performance problem (on everything that I do on my local SQL installation via Enterprise manager) and I have this "feeling" that probably at the bacground it is still searching for the old SQL installation??? Can someone please guide me regarding how to get out of this (without re-installating everything).
View Replies !
Domain User Account
New to SQL Server. Plan to install SQL Server 2005 standard edition on Windows 2k3. After searched a lot of places, still don't understand what exactly "domain user account" is. Could someone explain it to me? 1. Is this a OS account where SQL Server is running? 2. Or, is this an account under domain controller on other machine? Is this an account on DNS srver? How do I create it? 3. Or, is this an account in SQL Server? Where is this account located? How do I manage it? TIA.
View Replies !
Editing User Account
ung txtConPass ko is ung Confirmation input textbox ung txtNewPass ko is ung New Password input textbox ung oldPass ko is ung Old Password existing ung highlighted texts ko, dat is not working. That is my problem. I need to check if the old password that he typed is existing. When it is existing, then update the db. But if not, do not update. The problem is, even if the password that he typed does not correspond to the user that he is editing, still the data is being updated. Please help me fix it. Maybe I have to use other codes. Tnx! Private Sub OK_Button_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles OK_Button.Click Me.DialogResult = System.Windows.Forms.DialogResult.OK Dim oldPass As String = frmUsers.UsersDataGridView.SelectedRows(0).DataBoundItem(2).ToString Dim check As Boolean = True If Me.txtConPass.Text.Length = 0 Or Me.txtNewPass.Text.Length = 0 Then check = False ElseIf Not Me.txtConPass.Text.ToString.Equals(Me.txtNewPass.Text.ToString) Then check = False ElseIf Me.PasswordTextBox.Text.ToString.Equals(oldPass) Then check = True Else End If If check = True Then Me.UsersTableAdapter.UpdateQueryBySearchID(Me.UsernameTextBox.Text, Me.txtNewPass.Text, Me.NameTextbox.Text, frmUsers.UsersDataGridView.SelectedRows(0).DataBoundItem(0).ToString) Me.Close() Me.txtConPass.Text = "" Me.txtNewPass.Text = "" MsgBox("Your account has been updated.", MsgBoxStyle.Information) frmUsers.Close() Else MsgBox("Unable to update data.", MsgBoxStyle.Exclamation) End If End Sub
View Replies !
Sa User Account Info
i usually use the windows authentication mode when accessing my sql server but now that i need to use the SA account i can't seem to remember the password. is there any way that i could just reset the password for the SA account?
View Replies !
Cannot Create Database Mail Account
Hello all, I get a strange error message when I try to create a Database Mail account. I know the script is OK because it works fine on another SQL 2005 Server. This script is as follows: exec msdb.dbo.sysmail_add_account_sp @account_name = 'SMTPAccount01' , @email_address = 'someone@somecompany.com' , @display_name = 'Sales System - Company Name' , @replyto_address = ''someone@somecompany.com' , @description = 'SMTPAccount01' , @mailserver_name = 'somecompany.com' , @port = 25 , @username = 'someone+somecompany.com' , @password = '1234' The error message I get is: Msg 15466, Level 16, State 2, Line 1 An error occurred during decryption. I tried installing SP2 and that didn't help. Someone help please! Thanks in advance. Jerome Smith
View Replies !
How Can I Create Account With Read Only Access?
Hello, We have SQL Server 2005 with 300+ databases in it. It was set up by the conractor. How can I create new account with read-only access to all databases? Is there any "quick" method of doing it (like in Sybase, it is very easy). I've created new login, but I do not see where can I set up the permissions properly. Thanks
View Replies !
Migrate A Local SQL User Account
whats the simplest way to migrate a user account from a master development SQL server to local development sql servers and also to a production server? we can recreate the SQL account everywhere, but if we take a backup from one machine and restore to another, we loose access because the accounts arent truly the same account.
View Replies !
NTlogin User Account To Sql 2000
is there a way to move login names or Win 2000 active directory to SQL? need to get NT login name, emp id to database so i can use for some other application and the way to automate update like in DTS THANKS
View Replies !
Urgent Problem With Dbo User Account
to make a long story short... our sql server crashed. I managed to recover the database without loosing any data but in the process the database user accounts became out of sychn. with sql logins. I resolved most of these by deleting the accounts from the sysusers table for the database. the one problem I have remaining is that the user dbo for the database has login value of blank or null... how do I get around this, I tried using sp_change_users_login but it sql did not like it. thanks for any help. Al
View Replies !
Permissions For Domain User Account
Hi, I want to use a domain user account not belonging to local admin or domain admin groups in SQL 2000/2005 Enterprise edition. This is what I've done so far.. On the machine that is the Domain Controller: - installed SQL 2005 as a domain admin - created a domain user account using Active Directory Users and Computers. This user is only "Member of" domain users; not any Administrators group. - added this user to SQL Server Management Studio->Logins and in Server Roles assigned sysadmin role. Question 1: Do I need to give any additional permissions to this user to work with SQL? Question 2: How can I test this user for basic SQL operations like database creation? Can I use Osql? Question 3: Can I use this user account to login to my domain controller using remote desktop? I tried adding this user to remote users, but in vain. Thanks!
View Replies !
How To Change The User Account And Password
HI, I m swagatika and working on a s/w company.I am facing some problem in MS SqlServer2005. my problem is:- i installed sql server2005 completely .At the install time , i set the username='xyz' and password=blank (windows authentication mode). Now i want to change my user account to 'sa' and password to blank. After installation,how to change the user account and password. Please can anybody help me ?
View Replies !
Reporting Services And ASPNET User Account
I have a asp.net, vb.net web application using sql and reporting services on a win 2003 server. I pass a @whereClause parameter to reporting services and reporting services responds with the data inside an iframe. Right now the report call works because I have set myself as a domain/user account in reporting services. What I would like to figure out is how to create a generic user/group in reporting services and when my web application calls reporting services for data, the web app uses its ASPNET credentials, which it runs under, to authenticate to reporting services. I wold in turn add the ASPNET user to reporting services and grant the group browser level security. I could also set up a generic user with impersonate = false userName="ReportWebUser" ... etc. I can't add all the different users/groups to reporting services, I would like to grant overall limited browser access. Any suggestions or leads would be extremely helpful. I'm not sure if my mind is just blank right now and it's an easy problem or it can't really be done.
View Replies !
Domain User Or Local System Account ?
Hello,My server is part of a W2K domain. What do you advice me as account torun my SQL*Server, service started with a domain user account or aslocal system ?I need advices from a security point of view.Thank's in advance
View Replies !
How Many People Can Login To SQL Server With The Same User Account?
I'm developing a client-server application using Visual Basic and SQL Server 6.5 for 700 users. The application currently requires users to login to the database using their network account (via trusted connections). Each of the users takes up a maximum of 6 connections. Unfortunately, other considerations will force us to discard use of trusted connections. So it only leaves us either to create 700 user accounts on SQL Server separately from their network logins or to create one SQL Server account and everybody uses that same account to login to the database. For political reasons, the customer would prefer not to ask their support group to maintain 700 user accounts on SQL Server if it can be avoided. My question: is there any technical limitation or other negative consequence of having 700 users login to the same account to SQL Server if SQL Server can handle that many connections (it would be 6*700 = 4200 connections) simultaneously? Are we supposed to do things like this? It seems that we don’t have better choice than this.
View Replies !
Creating WorkGroup/User Account In MSDE2000
Hi I am using MS Access project as a frontend and MSDE 2000 as a backend database. I have few users and i want to give every one restricted access to database based on their use. How can i create user accounts. I checked tools-->Security--> but workgroup admin option is not active. How to solve this puzzle Thanks in advance Neha
View Replies !
SQL Server 2005 Agent - User Account
Who needs to invoke the jobs in SQL05? Manually executing the job import_myteam as a user with dbo privileges fails. So, which user account should be assigned to successfully run scheduled jobs (ie, dbo)? The package file for the job in question is located in the server€™s C:Documents and SettingsuserxyzMy DocumentsVisual Studio 2005ProjectsIntegration Services Project3Integration Services Project3MyTeam (1).dtsx, but this still fails when the user userxyz is logged on and is executing the job directly from the server console. Step1 of the package executes as userxyz Step 2 fails and runs as cpmc-casql02 The user account userxyz has administrator rights to the server as well as being a sysadmin of the SQL2005 database (named cpcasql02). The account cpmc-casql02 is a €śpublic€? user of the database and is a member of the administrator group on the server itself. This same scenario carries for tasks as simple as truncating a table and importing the contents of another table in the same database. All of these jobs exhibit the same behavior whether run directly from the server console on remotely from a workstation connected to the SQL2005 database. Attempting to get a really simple job working, we also created a very simple SSIS package which does a select from a database table and writes the output to a text file. When running the same package from the user€™s workstation within Visual Studio, the package executes successfully. Once copied to the server, and run from within SQLServer as MyJunePackage however, the execution fails in the same manner as described above. The first step executes successfully as the logged-in user and the second fails executed under the account cpmc-casql02. So, again we have the same behavior of sequential steps being run as different users with unsatisfactory results. Please advise as to how to set up these jobs to run correctly and consistently. Thanks very much,Eric W
View Replies !
Check If A Windows/nt User Account Exists
I have some script which creates/grant priveleges to windows/nt users to DB but i frequently get the message below: Windows NT user or group '<user or group>' not found. Check the name again. I understand that this is because the said user/group is indeed not present in the environment I'm running the script (ie. testing and production environment). But is it possible to have some sort of checking whether the user/group exists in the environment so that I could determine whether or not to call some lines of code? Not sure if this is possible so i had to ask. c",)
View Replies !
How To Use Sql Server In Limited Window User Account
Ankush Jain writes "I m using Sql Server 2000 in Windoes XP (SP2) with Limited Window Account. I m new to Sql Server.Please You can tell me how to create database. When i expand the console root in Enterprise Manager it will show an error : "A connection could not be established to Local""
View Replies !
Setting Permissions In Sql Server 2005 For Asp User Account
How would Set permissions Sql Server 2005 so that I can access a asp page created in VWD and Sql Express. On the production server i have just the one instance of Sql I have the following connection string in the web config file: <connectionStrings> <add name="ConnectionString" connectionString="server=serversNameXPRESS;uid=aspuser;pwd=aspuserPassworkd;database=DATABName" /> </connectionStrings> The account i setup to access the db in Sql 2005 Proper on the Production serve is Represented by the name in the above example as “aspuser�. I created this user in security, logins. And I gave permissions to this on the Db level “create procedure delete, select, update insert.� I get a error when i run the page in the browser that says “login failed for aspuser.� I know virtual directory is configured properly. I can run aspx page in the directory with out a db connection, without and error. Any help would be greatly appreciated.
View Replies !
User Account Problems After Detach And Re-attach Of Db On Same Server
The short of this is, I detached and reattached a database on the same server and had some user account problems. The details are, I have a custom VB application (front-end) that uses a SQL database. Application users connect to SQL using a single SQL account ("dbuser"), that is a member of the dbo database role for that database, and the app implements it's own security from there. There is another SQL account ("dbuserrpt") that only has db_datareader database access for ad hoc reporting (Access/ ODBC). I wanted to move the database files to another location on the same server, and make copies of them. So I copied the files (after using sp_detach_db) to their own folder. After I ran sp_attach_db to the new file location, I was able to connect to the database, through the app, with the "dbuser" user account, but when I tried to print in the app it said something like "could not connect to SQL server". Likewise the "dbuserrpt" account couldn't connect from Access/ODBC. So I re-attached to the original files, and still had the problem. I then restored the database, which I backed up just before doing anything, and still had the problem! So I right clicked the database in Enterprise manager, when to properties, permissions, and for the "dbuser" account I checked the "create table, create view, create sp, create default, etc. boxes, and they are able to print now. For the "dbuserrpt" account I double-clicked the database in Enterprise manager, went to Users, double-clicked the "dbuserrpt" account, I highlighted Public (under “Permit in database role”), went to the permissions tab and checked all the Select column boxes. I did the same for the db_datareader properties. The user was then able to use the "dbuserrpt" account for their Access/ODBC reporting. My question is, what happened? I think if had restored the Master database when I restored the original db files, that that would have put me back to where I was. My concern is that the user accounts/permissions are not setup correctly now, and I have given them too many rights, etc. Everything has been working OK, but I'm uncomfortable, and need some feedback on this. Any help would be greatly appreciated. Robert
View Replies !
NT AUTHORITYNETWORK_SERVICE Vs Local User Account In SQL-Server 2005
Hi all, I've recently installed SQL-Server 2005 on our production server (win server r2, .net framework 2.0, 3.0 etc ..). In order to improve the security mechanism I'm allowing only windows authentication (not mixed mode). If each site and the sql-process is given a specific user account, could it have some bad performance issues ? Security-wise, which is better ? Few things to point out: 1. The SQL process was assigned with a local user account (i.e : [machine name]SqlServerUser) and not using NT AUTHORITYNETWORK_SERVICE. 2. Every ASP.Net site on the server assigned with a local account (i.e : [machine name]SomeSiteUser) through the IIS's Directory Security tab and not using IUSR_[machine name]. 3. Each "Site User" has the appropriate database authorization in sql. Any given help will be appreciated, thanks.
View Replies !
Drop And Add A Sql Server Login Account To Each User Database
I would like to write code to delete and add a SQL Login to every User database on my development server. Whenever I restore databases to dev using production backups the SQl Server logins are invalid and I need to delete them from the user database and add them again. I've already hard-coded a sql server job with n steps... a step for each user database to drop and add this sql user to each database. This isn't optimal since I have to add or delete a step everytime a user database is added or deleted. Does anyone know how to write a loop or cursor that does this dynamically? I am doing something syntactically wrong related to the GO statement. declare @db varchar(100) declare @message varchar(3000) DECLARE user_cursor CURSOR FOR SELECT top 1 name FROM master.sys.databases where name not in ('master','tempdb','model','msdb') OPEN user_cursor FETCH NEXT FROM user_cursor INTO @db WHILE @@FETCH_STATUS = 0 BEGIN SELECT @message = 'use '+@db + ' GO' +'DROP USER [SQLLogin.DataEntry] CREATE USER [SQLLogin.DataEntry] FOR LOGIN [SQLLogin.DataEntry] EXEC sp_addrolemember N''db_datareader'', N''SQLLogin.DataEntry'' GO ' execute @message print @message FETCH NEXT FROM user_cursor INTO @db END CLOSE user_cursor DEALLOCATE user_cursor
View Replies !
TempDb Drops User Account On Server Restart?
Please forgive my ignorance, I am by no means a SQL Expert, but have encountered a strange issue. I have 6 SQL Servers, Primarily SQL 2005 (one older SQL 2000) all loaded on Windows Server 2003 SP1. We use the servers for a proprietary database that we created which is the backend to a software package we sell. The issue I have is: We have added a Security account to the servers, and in one case we have granted rights for this account to the TempDB system database. However, whenever we restart this server SQL drops this user account, thus severing connectivity for the app that is relying on that account. I have set the account as DB-Owner etc, but nothing sems to keep it on re-start. Any input would be greatly appreciated.
View Replies !
MSSQL Server 2005 Reported Account Locked Out For User 'sa'
Greetings, I receive an error message in event log when i try to connect to the Database Server using ODBC on a client machine. The database server is running on Windows 2003 Server Standard Edition and the client machine is Windows XP Professional. Following is the error message from the event log: 2147467259 - [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa' because the account is currently locked out. The system administrator can unlock it. What causes the error to occur and how to resolve it?Appreciate for your assistence. Thanks and regards, Viknes
View Replies !
SQL Database User Account Access Remotely Via SQL Management Studio Express
Hi, I hope you can help.I have configured a Windows 2003 web server and SQL 2005 Server (on same box) to successfully allow remote connections and to allow access via SQL Server Management Studio Express 2005.The problem I have is that I want to restrict access to the databases on the server via the Management Studio to specific databases e.g. 1 database user "sees" only 1 database.I can configure it so that the user's remote access permissions do not allow access to other databases but they can still "see" the database listed in the Management Studio explorer.I can also configure it so that the users cannot see all the databases (by disabling View All Databases on SQL Server), but this means that they cannot not see their own database which they have permissions for.Is it impossible to have the desired behaviour of only displaying the database which the remote user accessing has permissions for and hiding all other databases?I have MSN'd,Googled and Yahoo'd this one to no avail :(Many thanksFergus
View Replies !
Problem In Using Linked-servers While Running MSSQLService Under Low-priv. User Account
Hi. While hardening a ms-sql2000 , I faced with a problem and I`m completely lost ! few days of reading and google searchs didn't gave me any hint... Here's the scenario : Ms-sql is connected to Oracle , through "MS OLE DB provider for Oracle" . By default MS-SQL runs as SYSTEM , but even if we change it to a "local admin" account , everything works fine . The problem is that it's not wise to let sqlservice to run under privilaged accounts such as system or a member of 'local administrators' . So I tried a normal local user on the host running sql . I fixed every related problem appearing because of using a limited user account and ms-sql works fine in all aspects but one ! While using normal-user account , sql-server fails to load linked-servers and this error pops up in enterprise-manager : "OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize returned 0x80004005: The provider did not give any information about the error." I've tried much to find root of this error ( including any comments from related KB articles... ) but no luck . My guess is that , using OLE requires administrative privileges on host , and as I'm running SqlService with normal user, it fails to use OLE. So I should give requried permissions to the user running SqlService . But the problem is that I've no idea where/how I should do that. I've already tried some registry/file permissions but non of them helped me. Some where I red that using ODBC instead of OLE may help , but that seems fail too ! *Note that I'm almost sure it`s a problem OUT of circle of ms-sql , meaning any modifications should apply OUT of ms-sql , because simply giving local administrative privileges to the user, fix the problem. Any comments? regards Hamid.K
View Replies !
Trouble Logging In To SQL Server 2005 Express With Domain User Account
Hi all, I have a SQL Server 2005 Express edition instance set up on one server, and IIS on another server. The SQL Server process account is a domain user account, which I have added to the local groups that SQL Server created during installation (I originally used a local user account instead of domain account; however, the problem occurs with both). SQL Server runs fine, and if I set my IIS application pool identity to a domain admin, my web app can access the database and retrieve the data necessary. However, I have a domain user account that I want to use to run the app pool and retrieve the data. The domain user account is added to the IIS_WPG group on the web server. On the database server, I have created a login for the account, as well as added it to the db_datareader role of the database that is used for the site. However, the user is not able to connect to the SQL Server. I get the "Login failed for user <user account>" error in ASP.NET. I also tried connecting with SQL Server Management Studio, and I get the same error. I checked and the user has connect permission to the database server. With admin accounts, there are no problems logging in, etc. Any pointers are appreciated, Thanks, SA. Edit: I was able to find out that the State is 11 for the error. According to http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx, this indicates "Valid login but server access failure." I am not sure how to resolve this.
View Replies !
SA Account (DBA System Account) Granting Priveleges But SQL Server 2000 Not Applying Them
I have been running a script in SQL Server 2000 as sa also as a Active Directory user who has administrator rights (I tested both approaches SQL Server then Windows Authentication) in Query Analyser which grants execute rights to the stored procedures within the database instance and Query Analyser does not give any errors when I run the script. I have made sure that each transaction has a go after it. I then return to Enterprise Manager, check the rights (I apply them to roles so that when we create another SQL Server user we just grant him/her rights to the role) and discover that the role has not been granted the rights. I seems to be occurring only with 2 of the procedures. Is there a known bug that might be causing this? yours sincerely Craig Hoy
View Replies !
Error &&"Logon Failed&&" - SSRS Service User Account Rights
I am facing a problem which is based on the restrictions on the domain of the customer. After deplyoing the report on the server we are getting the following error message in the report manager after executing (clicking) a report link: Logon failed. Logon failure: the user has not been granted the requested logon type at this computer. (Exception from HRESULT: 0x80070569) I googled for that and it seems to be an authentication issue where some user / account is not granted to log on as service / locally, but the problems is better described than the solutions. Did anyone faced that problem so far ? Which account has to be granted what priviledges or permissions in Windows. We are using a SQL Server 2005 / Reporting Services 2005 running on the same machine whereas the virtual directories Reports and Reportserver are running in a separate Application Pool Thanks, Thomas
View Replies !
Xp_cmdshell Does Not Execute For Non-sysadmin Account Even With Proxy Account
Hi all, i hope you can help me. Basically a dts package has been setup that pulls in data from another companies server, this data requires to be on-demand i.e individual users can pull in updates of the data when they require it. I am using xp_cmdshell and dtsrun to pull in the data. This obviouly works fine for me as i am a member of sysadmin. Books online quotes " SQL Server Agent proxy accounts allow SQL Server users who do not belong to the sysadmin fixed server role to execute xp_cmdshell" So i went to the SQL Server Agent Properties 'Job System' tab and unchecked 'Non-sysadmin job step proxy account' and entered a proxy account. The proxy account has been setup as a Windows user with local administrator privilages and even a member of the sysadmin server role - just in case. Now when i log onto the db with my test account - a non-sysadmin - and attempt to run the stored proc to import the data i recieved the message 'EXECUTE permission denied on object 'xp_cmdshell', database 'master', owner 'dbo' ' hmm... so basically i have either misunderstood BoL or there is something not quite right in my setup. I have search the net for a few days now and yet i can find no solution. Can anyone help?
View Replies !
|
TRACKER
