Sp_addlinkedsrvlogin: There Is No Remote User Xxx Mapped To Local User
Sep 7, 2007
I am creating a linked server to Sybase via ASE OLEDB provider
The following statement
EXEC master.dbo.sp_addlinkedsrvlogin
@rmtsrvname = N'QRY1', @locallogin = NULL ,
@useself = N'False', @rmtuser = N'beg', @rmtpassword = N'4502342'
gets error:
Msg 15466, Level 16, State 2, Procedure sp_addlinkedsrvlogin, Line 91
An error occurred during decryption.
Msg 15185, Level 16, State 1, Procedure sp_addlinkedsrvlogin, Line 98
There is no remote user 'beg' mapped to local user '(null)' from the remote server 'QRY1'.
Did I missed anything?
View 2 Replies
ADVERTISEMENT
Nov 10, 2006
I am trying to add a linked server from a AMD x64 server (Windows 2003) with SQL Server 2005 64 bit to a Server running SQL 2000. These are not in the same domain.
I can create a linked server using the option "Be made using the login's current security context" but can not when trying to specify the security context, i.e. sa and the sa password. When I try I get the following message:
Msg 15185, Level 16, State 1, Procedure sp_addlinkedsrvlogin, Line 98
There is no remote user 'sa' mapped to local user '(null)' from the remote server 'DTS_FSERVER'.
I have several other x64 server that I have no problem creating a linked server and specifying sa and the sa password.
The problem with using "the login's current security context" option is that I get an error when trying to run any Jobs against the linked server. The job fails withe the following error:
Executed as user: NT AUTHORITYSYSTEM. Access to the remote server is denied because no login-mapping exists. [SQLSTATE 42000] (Error 7416). The step failed.
I'm sure the two errors are related. Any ideas what is going on?
View 7 Replies
View Related
Dec 7, 2006
This is my first time to deploy an asp.net2 web site. Everything is working fine on my local computer but when i published the web site on a remote computer i get the error "Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a local user profile on the computer. The connection will be closed" (only in pages that try to access the database)
Help pleaseee
View 3 Replies
View Related
Apr 28, 2008
Hi all hope some one can help - please bear with me new to this
Basically I have had to change pc's so I copied and pasted my ASPNET.MDF and LDF from my old pc to new PC including webpages/apps etc.. created.
However now all I get is "Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path """"
Just don't understand what permissions the db should have, does it need to match the SQL Express owner...
any help would be most appreciated
Thanks
Chris
View 5 Replies
View Related
Jun 21, 2005
I installed my asp.net 2.0 web application and sql express june editon on my windows 2003 server.When the application tries to reach the database i am getting the following error"Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a local user profile on the computer. The connection will be closed."I can understand that it has something to do with user right but more than that I am pretty lost. Can anyone translate this error for me and give me some tips on what do to.I checked first the user running the sql express service and saw it was the NETWORK SERVICE user. I changed it to be the local system account but that did not make any difference. The application is running just fine on my local computer(Win XP sp2). This one has SQL express April edition though.
View 3 Replies
View Related
Oct 6, 2006
My replication is not working. I was able to create a transactional replication successfully. However, when i tried starting the agent on the snapshot, it wouldn't work. I figure that it was because my agent service login is different from that of the subscriber. my publisher and distributor is on local user whereas my subsciber sql services use our global login.
Thank you in advance. Good day!
View 3 Replies
View Related
Mar 5, 2015
If a user is mapped to "master", (in login properties, user mapping) are they able to access all dbs, even though "master" is the only one with the check mark?
View 3 Replies
View Related
Aug 17, 2007
Is there a form of ALTER USER or other option that would allow me to change the Windows-based login associated with a user account?
According to BOL, I cannot use the sp_change_users_login trick since I want to rewire up to a Windows login, not a SQL Server login.
-- Margo
View 1 Replies
View Related
Jun 26, 2007
This has been extremely confusing for me.
I want to just make a simple backup.
first of all when i choose the pick a folder to backup, no mapped drives I make are even THERE.
I realize this is probably related to the account being used, okay I thought let me change the user account to a network admin account... I still cannot see the drive.
Can't this thing just accept whatever I tell it to access like any other program??
You would think they would at least keep the standard Open File dialog so we can use the network browser or something...
I've changed my accounts all to NETWORK SERVICE, then LOCAL SYSTEM, then a DOMAIN ADMIN...
I can't get this to work correctly on this freshly installed server... can someone please help?
I'm at the point where I don't care if i have to just re-install the damn thing...
Just someone please tell me what to pick for the accounts.
Bonus: I have this same issue with reporting services and Services for Unix NFS Mapped drives.
How can I map a drive with NETWORK SERVICE Credentials so it finds the datasource path?
I've only been able to do something like this with psexec and Local System.
When logged in as Domain Admin it will show a disconnected network drive that you cant get rid of but system account can use.
View 3 Replies
View Related
Oct 22, 2007
We recently upgraded to SQL 2005 from SQL 2000. We have most of our issues ironed out however about every 1 minute there is a message in the Application Event log and the SQL log that states:
EVENT ID 18456 Login Failed for the users DOMAIN/ACCOUNT [CLIENT: <local machine>]
This is a state 16 message which I thought meant that the account does not have access to the default database. The account is actually the account that the SQL services run under.
Any ideas? We can't seem to figure this one out. We actually upgraded to 2005 from 2000 and had an error appear after every reboot that prevented the SQL Agent from running(This application has failed to start because GAPI32.dll was not found. Re-installing the application may fix this problem.) We did a full uninstall of SQL and reinstalled fresh and restored the databases from .bak files and that is when the EVENT ID 18546 started occuring every minute.
We don't have any SQL heavy hitters here so please be detailed with any possible solutions. That you very much for any help you can provide!
David
View 5 Replies
View Related
May 22, 2008
Hi,
Please give the T-SQL script for this ? Thanks
Shanth
View 4 Replies
View Related
Mar 5, 2004
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 2 Replies
View Related
Feb 6, 2007
Just when I think I have this stuff figured out, it bites me back everytime.
I'm
trying to deploy an mdf out to a different machine, and attached to it with local user instance. I connect without problem from my development
machine with a local user instance, which also has Express Manager resident,
and I can connect to a server instance without problem.
What I can't do is
copy the .mdf database over to another workstation, which has Sql Native
Client installed, and connect to the database using a local user
instance! I can connect to a server instance without problem from this
other workstation. Here's my connect string for local user instance
that works fine from my dev machine:
Provider=SQLNCLI.1;Persist
Security Info=False;Integrated Security=SSPI;Data
Source=.sqlexpress;AttachDBFileName=<full path_name and mdf
filename>;User Instance=true;
The error I get upon trying to connect with other stations is:
Error -2147467259
Database not found or cound not connect to database
I've
tried this every way I know how. I've copied the database from my dev
machine both with and without having detached the database from the
local instance. I've tried detaching from a server instance and copying
the file over. Nothing works, and I've done this before! What gives with this thing?
Rick
View 5 Replies
View Related
Feb 10, 2014
I am newbie to SQL.I need to create an application will run on server, and of course will be installed by using admin user. I can use the install user to access to database on that server?
View 1 Replies
View Related
Mar 24, 2004
I'm having a problem declaring variables in UDFs. Are they allowed? Can someone send me some syntax to see what I am doing wrong?
View 4 Replies
View Related
Jul 20, 2005
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 4 Replies
View Related
Mar 17, 2008
I have been reading through the article pointed to by the link below on msdn and its documented that one functional limitation of user instances is "Only local connections are allowed." I didn't understand the technical details(meaning) of that limitation and hopefully some one might explain it to me so that i can understand it better.
View 6 Replies
View Related
Mar 6, 2014
Is there any way sa user can access folder located in local system.
Server Info:
SQL Server 2008 r2
OS: Windows Server 2008
View 1 Replies
View Related
Jan 23, 2008
One of my co-worker changed the sa password today. After that we are getting this error. The SA account gets locked every time. Even within few seconds of unlocking the SA account, it gets locked again. Error message is not clear as what session still using old password and causing the SA account to get locked? Any of our application does not use SA user to connect to databases. We have Tivoli installed on the same system and the GUI of tivoli has the correct password.
Shailesh
View 3 Replies
View Related
Aug 14, 2007
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 4 Replies
View Related
Sep 16, 2007
Hi, im new to here and SQL server.
I am building a program in vb.net 2005 as a booking system using SQL server as backend. I have just finally managed to get SQL server working on the server, DIY Windows XP Server, but I cannot make remote logins. I have my client computers connected through a workground called JNKVPN. I can connect to all the client computers on the network through the workgroup computers menu off network places. I want to add a remote user account to SQL Server management studio express but none of the client computers are listed as domains.
Is there any way I can get them listed. I have been getting very fustrated with this and i need to have the program i am writing completed by 28th Sept 2007 so this is really delaying me substatially.
Thanks in advance for reply's
Regards
Matt
View 4 Replies
View Related
Nov 6, 2006
Hi Friends,
I am getting the below error while installing CSF DevLite edition on
Following is the breif Info
Server Is : Win2003
SQL SERVER 2005 Installed on Same PC
Domain Name is : Test
User : Administrator he is a build in Admin,
PLEASE HELP ME!!!! Thanking in advance.
EVENT LOG 1:
Login failed for user 'TESTadministrator'. [CLIENT: <local machine>]
EVENT LOG 2:
The description for Event ID ( 11609 ) in Source ( MsiInstaller ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Product: Microsoft Connected Services Framework 3.0 Developer Edition Lite -- Error 1609.An error occurred while applying security settings. Power Users is not a valid user or group. This could be a problem with the package, or a problem connecting to a domain controller on the network. Check your network connection and click Retry, or Cancel to end the install. Unable to locate the user's SID, system error 1332, (NULL), (NULL), (NULL).
View 7 Replies
View Related
Jul 29, 2006
I just did a fresh install of SQL Server 2005 Developer Edition and SP1. I elected Windows auth during install. After rebooting I get 2 errors in my Application Event Log: MSSQLSERVER Login failed for user 'COMPUTERuser'. [CLIENT: <local machine>] (event ID 18456) and Report Server Windows Service (MSSQLSERVER) (event 107) which says: Report Server Windows Service (MSSQLSERVER) cannot connect to the report server database. In the data section it says it can't connect to the machines "master" database. I can manually login. How can I fix the problem and get rid of these messages? Thanks. Mark
View 11 Replies
View Related
Oct 31, 2007
Hello guys and girls! I need help for this error. Could anyone be so kind to enlighten me on this? Thanks!
When i attempted to login to my local page, this occurred:
View 3 Replies
View Related
Dec 4, 2007
I have Developer's Edition of SQL Server installed on my PC. I want my users to run and view my new RS report from their PCs across the network without installing SS on their machines.
We experimented a little bit by asking one user to use these URLs...http://mymachine/reports$myinstance and http://mymachine/reportserver$myinstance) after giving her browse rights in report manager from my PC.
When she uses the first URL, she gets a popup asking for sign in info, but gets nowhere when typing in her windows sign in info. When she uses the second, she gets thru to the report choices but gets an error like...
* An error has occurred during report processing. (rsProcessingAborted)
* Cannot create a connection to data source 'xxxxx'. (rsErrorOpeningConnection)
* For more information about this error navigate to the report server on the local server machine, or enable remote errors
...after choosing my report. xxxxx is the name of the only datasource in the report.
Before we began, we also turned off 'enable anonymous access' and instead clicked 'integrated windows authentication' in IIS on my pc.
My user is on a different domain controller than I am. I asked a colleague who is on the same domain controller to try the URLs and he had no problems running my report from either. He wasnt given any explicit permissions/rights at either the reporting or db level.
Does anyone have a clue?
View 6 Replies
View Related
Mar 1, 2001
Hi,all.
I tried to issue:
sp_attach_db pubs,'F:anthonypubs.mdf','F:anthonypubs.ldf'
where the pubs.mdf and pubs.ldf are on a remote mapped drive F:,
I got error:
Server: Msg 5105, Level 16, State 4, Line 1
Device activation error. The physical file name 'f:anthonypubs.ldf' may
be incorrect.
Is attaching a database ONLY supported for local servers ??
What about creating database on remote drive? (I have same error msg back)
Thx
Anthony
View 1 Replies
View Related
Aug 24, 2006
I am able to use user data types for creating local temporally tables in store procedures, but I receive an error at run-time about the user data type.
Msg 2715, Level 16, State 7, Procedure SP_SAMPLE_TEST, Line 4
Column, parameter, or variable #1: Cannot find data type D_ORDER_NUMBER.
The same user data type is used as parameters in several other store procedures, and they work perfect. It is also used in several table definitions.
What am I doing wrong?
Thanks in advance to any one who can help me with this problem.
Diego Sierra
View 4 Replies
View Related
Apr 18, 2008
1Is it possible to choose local user,(instead of local system) in sql setup service login and then use mixed mode
default configuration in report server or choose configure server later. I will be using a third party host using vista, unfortunately I do not have my own server ( I do not have a domain yet)
vista sql 2005 standard vs 2008. ultimate
2 What is the best configuration for a new aspiring asp.net ssrs developer.
3 Do I need to configure the server if I choose local user?
4. what is the best way to configure sql?
By the way what items
should I look forward in choosing a web host,(who is willing to give alot of help to developers) my interests include ssrs 2008 sql 2008 sql 2005
asp.net mvc, crystal reports, wcf infragistics. I am really interested in showing
examples in sql reporting services, crystal reports wcf , web services , infragistics
asp.net mvc intrigues me.......
I would like to get on a track to eventually use sharepoint services
Thanks again, I know I ask I alot of questions........
View 3 Replies
View Related
Oct 11, 2007
I've noticed at least five other posts on the web with this problem with no solutions given. Seems there are MANY people with this particular problem--hint:Microsoft Pay Attention. Help!
When installing SP2 for SQL Server 2005 I get this error message:
MSI (s) (E0!68) [09:02:25:673]: Product: Microsoft SQL Server 2005 (64-bit) -- Error 29512. SQL Server Setup was unable add user OUR-LAN-DOMAINOUR-SERVICE-ACCOUNT to local group OUR-LAN-DOMAINSQLServer2005SQLAgentUser$OUR-DATABASE-SERVER-NAME$MSSQLSERVER.
The error message seems to contradict itself: it says "local group" which seems to me to mean the group on the database server itself YET the group name is prefixed with our LAN domain name. So which one is it?
Also, I'm not sure if this message means there is a problem in Active Directory or in the security model of SQL Server itself. I don't think it means SQL Server itself because I don't think SQL Server has groups... it only has Roles, right?
We looked in Active Directory and the user above does indeed exist in the domain-level group mentioned.
Please help!
View 9 Replies
View Related
Nov 28, 2007
Maintenance plan for bakcup is failing with "Login failed for user 'sa'. [CLIENT: <local machine>]"
I went to the Maintenance Plan and opened the Subplan. I clicked the "Manage Connections"
It has three tabs:
Name: Local Server Connection
Server: prod
Authentication: SQL Server Authentication
I clicked the Edit and it shows the Connection Properties:
It says: Enter information to logon to the server. "Use a specific Username and Password" is checked. Username is set as "sa" while the password is empty. I typed in the correct password and pressed Ok. When I go back again, the password still shows empty. I tried to run the plan and it again fails. Do you know why it is not showing the password as blank even if I try to save the password.
View 1 Replies
View Related
Sep 28, 2007
When I am in Visual Studio 2005, and I try to add an SQL database, I get the following error "generating user instances in sql server is disabled. use sp_configure user instances enabled to generate user instances." I am currently using SQL server 2005 Express. What do I need to do, to create an SQL database? Thanks in advance.
View 4 Replies
View Related
Oct 12, 2006
Is it possible to get the latest inserted Identity value on a remote server?
(The following gives a NULL result:
select ident_current('[my_linked_server].thedatabase.dbo.thetable')
)
View 4 Replies
View Related
Jun 17, 2007
I was able to do this on a Windows XP machine but I am not able to get this to work on a Windows 2003 Server machine.
I am connecting to the Windows 2003 Server and MS SQL Express via remote desktop on the lan.
This is what worked for me before:
EXEC sp_grantlogin '4800X2ASPNET'
USE MyDB
EXEC sp_grantdbaccess '4800X2ASPNET'
EXEC sp_addrolemember 'db_owner', '4800X2ASPNET'
But for some reason now I am getting this error:
Msg 15401, Level 11, State 1, Procedure sp_grantlogin, Line 49
Windows NT user or group '4800X2ASPNET' not found. Check the name again.
Msg 15401, Level 16, State 1, Line 1
Windows NT user or group '4800X2ASPNET' not found. Check the name again.
Msg 15410, Level 11, State 1, Procedure sp_addrolemember, Line 75
User or role '4800X2ASPNET' does not exist in this database.
I thought what I needed to add was the name of this pc that will connect remotely, but that doesn't seem to be working.
What weird is the old copy of this query I used had the local pc as the computer name. If I exchange the computer name from the remote pc name to the local 2003 Server machine name, the query works fine. Although that still doesn't let me add connections via Web Developer Express without error. It doesn't make sense to me anyhows, how could I have used the local machine's name and not the remote machine's name to get this to work previously. So confused.
Thank you in advance for help.
View 1 Replies
View Related
