Cannot attach database from Server management Studio

Programming and Web Development Forums - MS SQL SERVER - Microsoft SQL Server

Skip to content

Cannot attach database from Server management Studio

MS SQL SERVER
Post a reply

    Next

  • 1. error: sql native client: login timeout expired
    Hi, I installes sqlserver 2005 express on windows server 2000 sp4 (name=pen1800). When running this: 'sqlcmd -S pen1800 -U administrator' in a dos window as administrator, i have first to enter the password and then i get this error: "Microsoft sql native client: login timeout expired" and further " ...it may be caused by the fact that under the default settingssql server does not allow remote connections." In sql server Management studio express, the properties of security is set on "windows authentification mode". The remote server connections is on. The sqlserver service and the sql server browser service are running. In sql server configuration Mananager, i can see that for the sql native client configuration, all clients protocols are enabled (shared mem, tcp/ip, named pipes, via). Any idea what's going on and how to solve this? Thanks Cas
  • 2. SQL Server Cannot Connect to Local Instance
    Hi, I have a SQL Server 2000 running on Win2k3. I uninstalled SharePoint so I could install Reporting Services and I upgraded to MDAC 2.8. I tried connecting to SQL locally on the Enterprise Manager on the machine but I get this error: "Server does not exist or access is denied." The odd thing is that I can connect to that SQL Server from other remote machines through Enterprise Manager, I just can't connect locally. All help is appreciated. Best, MC
  • 3. Oracle with SSAS connection
    Hi, I am trying to deploye a cube on SSAS (64 bit) and the data source is connecting Oracle 10g 32bit to get data to generate cubes, my PC has Oracle 10g Client (32bit). when I build the cube, it done successfully but when I deploye this cube it gives following error. Error 1 Errors in the high-level relational engine. The following exception occurred while the managed IDbConnection interface was being used: Attempt to load Oracle client libraries threw BadImageFormatException. This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed.. 0 0 Error 2 Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Oracle DW Call Detail', Name of 'Oracle DW Call Detail'. 0 0 is there any suggestions to solve it ? -- Regards, Muhammad Kawish Siddiqui +92-321-5020447

Cannot attach database from Server management Studio

Postby Sen D » Tue, 31 Mar 2009 21:46:46 GMT 

When I try to attach a local database file created with SQL Express 2008 / 
Visual Web Developer, I get following error

Cannot show requested dialog.
Parameter name: nColIndex
Actual value was -1. (Microsoft.SqlServer.GridControl)

I have read that this has to do with user credentials, but I dont 
understand, I just find the local database instance using Windows 
Authentication and my user is local administrator.

Does anyone know how to get around this?

Best regards
Soeren
Top

RE: Cannot attach database from Server management Studio

Postby U2hlaGFiIEthbWFs » Tue, 21 Apr 2009 03:56:15 GMT 

I have installed SQL server to support mixed authentication.
If I connect using windows authentication, I get the same error you have. 
However if I connect using sa account I am able to attach the database. So 
try to enable the sa account and log in using it.
Top

Re: Cannot attach database from Server management Studio

Postby William Vaughn (MVP) » Thu, 30 Apr 2009 01:47:50 GMT 

Not a good idea. It's rarely (if ever) prudent to build an application that 
connects via the SA account. It opens the server to a variety of attacks 
often caused by the dispersal of the SA password--not to mention Trojan 
attacks.
If SQL Server authentication is called for, create a new Login ID for the 
application and grant it specific rights on the target database.

-- 
__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205  (Pacific time)
Hitchhiker Guide to Visual Studio and SQL Server (7th Edition)
 http://www.**--****.com/    http://www.**--****.com/ 
____________________________________________________________________________________________
Top

Re:Cannot attach database from Server management Studio

Postby Michal Hanus » Mon, 28 Dec 2009 23:35:11 GMT 

Hello, this appear to "bug" in management studio. In my situation, after get 
this error I try attach database from t-sql command sp_attach_db and success 
attach database :-)

url: http://www.**--****.com/
Top

Similar Threads:

1.Cannot see BCM database in SQL Server Management Studio 

I'd like to see the database structure of my personal BCM in the studio 
manager for SQL Server but cannot. I refuses to even attach it even though I 
am administrator on the box.

2.Cannot expand Databases in Management Studio Express 

Hi,

I use Management Studio Express 2008 to access my shared hosted SQL 2005 
Standard.  I can login to my Db and run sql statements in management studio. 
However when I try to expand the "Databases" in "Object Explorer" I get:

"The server principal "my_username" is not able to access the database 
"someone_elses_DB" under the current security context. (Microsoft SQL 
Server, Error: 916) ".

So I looked into "my_username" login property and it shows "My_DB" as 
default database which is correct. But I don't undrestand that why error 
message is pointing to "someone_elses_DB" !

Any idea?


Regards


Med

P.S I only have limited permissions on hosted SQL Server, and "my_username" 
is db owner of "My_DB".

3.Windows 7 SQL Server Management Studio cannot connect to SQL Server 2005 - SOLVED 

Searching for help on this problem, I found a lot of stuff having to
do with server configuration, and other distractions, and having
figured out the solution (at the end of at least 4 hours of
thrashing), I wanted to share it for the benefit of others.

PROBLEM: A Windows 7 machine with SQL Server Management Studio 2005
can connect to the localhost SQL Server 2005 instance, a "regular"
remote SQL Server 2005 setup (CrystalTech's web hosting), and a SQL
Server 2000 instance on a server with a VPN connection.

I could NOT connect to the SQL Server 2005 instance on the VPN, UNLESS
I turned off the firewall for the "Public" profile..

SOLUTION:
The win7 firewall configuration had 2 pair of inbound rules for SQL
Server Management Studio, allowing any UDP and any TCP ports, for the
"Private" and "Domain" profiles. None of these was enabled.

I changed one pair to serve for all three profiles, enabled the pair
of rules, and I was able to connect.

4.Cannot change Server authentication in Management Studio Expre

5.Cannot change Server authentication in Management Studio Express 

I use the Management Studio Express to manage a MSDE 2000 instance and notice 
that the Server authentication area in the Security is disabled for that 
instance. But for an Express instance, the Server authentication area is 
enabled. Is this difference caused by some settings?


Thanks,

Peter

6. cannot open table in sql server management studio express

7. Cannot get into SQL Server Management Studio 2008 - faulting modul

8. Cannot connect with SQL Server Management Studio to SQL2K5

Post a reply

Return to MS SQL SERVER

 

Who is online

Users browsing this forum: No registered users and 60 guest

Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group