Cannot attach database from Server management Studio

MS SQL SERVER

    Next

  • 1. Login to Local SQL Server
    Unable to login to Local SQL Server in order to retrieve info in a DataSet. No problem when using Enterprise Manager or from within VStudio server Explorers. Also no problem with coding as able to connect to retrieve info from remote server. Therefore, feel problem lies with permissions or something. Server is set to accept both SQL Security and Windows Integration... I should have full access as it is completely own and setup by me... Can someone please help... this has been dragging on a few days and I'm at the end of the line. New user. Pwease!!
  • 2. "SQL service network card bindings"
    Is it possible bind the SQL service to a specific network adapter in a multihomed machine w/ diffent subnets on each adapter? If so How? Thanks, ZAN
  • 3. Repository engine V3.0...
    All of a sudden, when I click on a SQL Server in the Entrprise Manager I get the following error in a megbox with an Ok button: Repository engine V3.0 or higher is required to run Meta Data Browser Then if I click Ok, then I get another msgbox with this mesage: Snap-in failed to initialize Name:Meta Data Services CLSID:{1DBA4DD4-EB97-4FD2-AB80-9D0D4BA74034} OS: WinXP SQL 2000 SP2 That in the heck is going on?? ->Noah
  • 4. Can not connect to SQL over internet connection
    I am having trouble connecting to an sql server over my internet connection on a LAN. I have set up DSN on the server, ( do I set a DSN server name on the client as well?). I can connect using a dial-up connection with this code but when I use my ISDN internet service, I have no luck. I am programming in VB and this is the code I am using Set cnn1 = New ADODB.Connection strCnn = "Provider=sqloledb;" & _ "Data Source=sql7.hostbasket.com;Initial Catalog=mydatabase;User Id=myusername;Password=my password;" cnn1.Open strCnn '' This is were the error occurs [Microsft][ODBC SQL ServerDriver][TCP/IP Socket} Specified SQL sever not found
  • 5. Max number of instances of a login
    Hello, can someone please tell me what is the max number of instances a single login can have open and running a query at the same time ? Basically i want to know if a user logs into a website and runs a query using a web login called 'weblogin' and at the same time more users try to execute the same query from the same web site using the same web login, will both queries run at the same time using the same ID, or does the second request have to wait until the first is complete to start? Trying to determine if i am going to have to create many separate logins to allow many people to run the same query as the same time. Thank you

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 


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.





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/ 
____________________________________________________________________________________________









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/ 

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



Return to MS SQL SERVER

 

Who is online

Users browsing this forum: No registered users and 12 guest