Re: sql server mgmt studio "Login failed for user x", "Error Number 18
Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance
Deejjaayy (Deejjaayy@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
The strange thing is, i know the database is up&running (i can browse our
website), and i know the username/pwd supplied by the hosting company is
still valid because:
(a) I can log into the remote DB via VS2005 using those credentials no
problem, and
(b) If I login in to a local DB from within Sql Server Mgmt studio, I can
successfully Import/Export data to/from the remote DB that I'm not being
allowed to log into!!!
The obvious thing to check is Caps Lock and that. Passwords are
always case-sensitive.
You can also try log in with SQLCMD from the command line.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
Relevant Pages
- Re: TS vs VPN
... Using TS, w/o VPN ... The remote client connects to your local TS via Remote Desktop. ... "Foo" accesses the SQL server, which is nearby in a protected part of the network. ...
(microsoft.public.windows.terminal_services) - RE: SQL 2008 - remote connection to the SSIS 2008 - Access denied
... SQL Server configures the appropriate rights during the installation process, ... then add users/groups and assign the appropriate permissions. ... user who created the package apply to the writer role. ... I checked DCOM MsDts component and my user rights for the Remote ...
(microsoft.public.sqlserver.dts) - Re: Remote Database Connection with PocketPC/MSAccess Front End
... If you want to allow direct remote access for your Access data, I'd suggest writing a web service which your remote apps could use. ... The general problem with mobile access to remote data of any kind (including SQL Server which Windows Mobile devices can access directly remotely) is that sometimes the connection just isn't there. ... Generally the easiest backend data store to use for this local cache is going to be SQL Server Compact, which supports several sync strategies including the Access Sync Services that your question isn't about. ...
(microsoft.public.pocketpc.developer) - RE: Login failed for user (null).
... used at signon to authenticate in SQL Server. ... connect the remote SQL Server database), is there any other data accessing ... What's the security identity used to access the remote SQL Server, ... the worker process identity. ...
(microsoft.public.dotnet.framework.aspnet.security) - RE: CTP3 Failure - Creating a Remote Distributor (error during decrypt
... with changes in the SQL Server service account after replication has been set ... Are the remote distributor and the publisher machines in the same domain? ... Are the distributor and publisher SQL Server Service running under domain ...
(microsoft.public.sqlserver.replication) |
|
