Cannot attach database from Server management Studio
by 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
RE: Cannot attach database from Server management Studio
by 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.
Re: Cannot attach database from Server management Studio
by 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/
____________________________________________________________________________________________
Re:Cannot attach database from Server management Studio
by 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/
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