DataSource Controls :: Managing Users In SQL Server 2008 Management Studio?
Jul 12, 2010
I restored a database from another server, and everything looks good except the users.
I'm managing all this from SQL Server 2008 Management Studio as SA.
The users are present in the [u]databaseName > security > users[/u] section, and they exist in [u]databaseServer > Security > Logins[/u]. However I can't change anything in the [u]databaseName > security > users[/u] section, because when I try and make a change, and then I hit OK to apply, it says "[i]login name must be specified[b][/b][/i]". But the login name field is grayed out and I can't modify it(even though I'm logged into the machine as Administrator and SQL as SA).
Also, in the user mapping section, when I try to map one of the users to a database, it says '[i]create failed user already exists[b][/b][/i]'...but I don't want to create the user, I just want to map that user to the appropriate databases...
View 2 Replies
Similar Messages:
Mar 25, 2010
I've just downloaded SQL Server Management Studio 2008 after using SSMS 2005 for the past years, however the intellisense isn't working in the Query-Builder. I've checked, and Intellisense is enabled. Is there any other reason this could not be working?
View 4 Replies
Jan 15, 2010
where can i download profiler from? i can't find it on google.
View 2 Replies
May 7, 2010
I sucessfully installed SQL Server Express 2010 on my windows server. I then tried to install the SQL Server 2008 management studio via Web Platform Installer but it failed (it did however sucessfully install powershell).
[Code]....
View 1 Replies
Mar 18, 2010
I have instance of MS SQL Server 2005 on my computer. Is there any way to install SSMSE (Management Studio) 2008 to work with instance of MS SQL Server 2005? Operational System of my computer: Windows XP with 32 bit, processor 1.67 GHz.
View 2 Replies
Mar 22, 2010
I installed MS SQL Express 2008 with Advanced Services including Management Studio 2008. When I connect to the SQL server of my provider (shared hosting - one SQL server for many customers), it takes very long (up to serveral minutes) until all DBs are displayed in the object explorer (from which I then have to choose my DB). Somebody told me, the long waiting time occurs because Management Studio first checks rights (whichever rights that may be) with every DB that runs on the server.
But in Management Studio 2005 the behaviour is different - the DB Tree in the object explorer expands immediately! No waiting time! Does anyone know a solution for this? I don't want to install two separate versions of Management Studio just because of that!
View 1 Replies
Apr 26, 2010
I have SQL Server Standard 2008 installed on my machine, alongside Visual Studio 2008.
My current hosting provider (not a huge fan) requires me to access my db's remotely via SQL Server Management Utility. To date, I've been doing it by connecting remotely in VS2008. Their troubleshooting documentation/steps, though, are for the SQL Server Management Express 2008, and i'm having a lot of connectivity issues with them.
I followed the steps here: [URL] to "add additional features to an existing installation" - but when I did so, the setup wizard indicated that the Management Tools-Basic were already installed.
View 1 Replies
Apr 30, 2010
I have installed a vs 2010 ulitimate . it's have Sql server 2008, but i want to Open SQL Server Management Studio 2008,
View 1 Replies
Apr 22, 2010
I have been given a .NET type web hosting by my provider along with MSSQL. I am learing what that means and how to use it. Can I use my SQL Server 2008 Management Studio to connect to that SQL over the internet in order to put my database on the web? or how else can I use it?
View 1 Replies
Jan 8, 2010
I have just installed SQL Server 2005 on windows7. It was installed successfully. When I tried to open SSMS it became faild. It gives me SQL Server Error :18456 Login Failed. How can i find what server name I put to login? Because when It prompt me to login, in server combo box it shows me only <browse for server> option and it doesn't show me any option to select server. I put the default John-PCJOhn it gives me an error. I uninstall it two times and installed it again but every time it gives me same error. It was working fine before formating my laptop. Please give me a solution to login in to SSMS.
View 4 Replies
Aug 11, 2010
I am having a problem connecting to my SQL Server 2008 Express database with SQL Management Studio Express and from the website at the same time.
Everytime I want to view any pages in my site that access the database, I have to close management studio and restart the server for some reason or i get a failed login error message. Then when I want to go back to SSMS I get this error message:
Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)
Additional Information: Unable to open the physical file c:..... Operating system error 32: "32(The process cannot access the file because it is being used by another process.)" (Microsoft SQL Server, Error: 5120)
Is it NOT possible to work on the database through SSMS at the same time as viewing pages in the website that access the database?
I sure hope that there is a work around or something for this.
Just in case my connection string is:
<add name="ApplicationServices" connectionString="data source=.SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true" providerName="System.Data.SqlClient" />
View 5 Replies
Mar 30, 2010
I'm a beginner with ASP.NET. I'm using SQL Server2005 Management Studio. The problem I facing is arises when I tries to run any query,even the simplest, it doesn't identifies the table. as below:
View 4 Replies
Sep 17, 2010
We use SQL Server 2005 and 2008 here at my workplace. In the past, whenever we setup a new developer workstation we would install Visual Studio, then install Management Studio by downloading the SQL Server trial, and installing only the tools. The tools (in the past) were setup so you could use them indefinitely, it was only the database engine itself that was time-limited.
With SQL Server 2008 that has apparently changed. I tried to start Management Studio 2008 on my workstation today, and got an error stating that "evaluation period has expired." I'm assuming we built this workstation the same as all the previous ones we've built, but now that I'm thinking about it I'm wondering if possible Management Studio was installed along with Visual Studio... is that possible? At any rate, my question is--how do we properly install Management Studio so that it won't "expire"? We don't need to install the database engine, we just want to install Management Studio.
View 3 Replies
Aug 27, 2010
I just installed SQL Server 2008 Management studio Express on my Vista machine.i tried connecting to local machine using :
.sqlexpress, (local)sqlexpress, or .SQLExpress, MyPCNAMESQLExpress
nothing is working, getting this error:
-----------------------------
Cannot connect to PC-NAMESQLEXPRESS. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
----------------------------
View 4 Replies
Feb 26, 2010
How do you import database diagram at SQL Server Management Studio Express (SSMSE)? Using SSMSE in checking my database through a shared server, the "Database Diagrams" folder has no import functionality.
View 1 Replies
Feb 3, 2011
I have the developers edition of sql server 2008 on my local machine (I have an msdn subscription). I would like to download and use r2 client, which I understand is superior to the standard client) but not the express database. Do I want the "SQL Server 2008 R2 Express with Management Tools " (doesnt sound like what I want) or the "SQL Server 2008 R2 Management Studio Express" (does sound like what I want, and is about 100M smaller, so I assume doesnt load the database). Of course I am assuming that the r2 client connects with no problems to a non-r2 database.
View 2 Replies
Oct 25, 2010
I have recently upgraded to SQL Management Studio 2008. The first thing I noticed is it wouldn't allow me to save changes to my table structure at all. I fixed this by disabling "Prevent Saving Changes that requre table re-creation" under Tools..Options...Designers...Table and Database Designers. Now it lets me save. However, if I rename a column in a table that has data in it, I get a warning telling me my data will be lost since the old column will be gone and the new column has no data in it. Since when does renaming a column require a table to be recreated? Is this some sort of setting in SQL Management Studio? If I can't don things like rename clolumns (even change column data types) without losing all my data, then what is the point of using SQL management studio?
View 2 Replies
Apr 18, 2010
I follow the instruction of installing a new feature with the application SQLManagementStudio_x86_ENU.exe and I get to a fail telling me that VS 2008 needs to be upgraded to SP1.
This I have done several times with the final message saying successfully installed yet 'About' shows only
Microsoft Visual Studio 2008
View 10 Replies
Jan 8, 2011
is it possible to put my database in the system databases in the program ?
View 2 Replies
Dec 23, 2010
I usually use WebMatrix to manage my database (sdf file). I wonder if it can be possible to manage this database with SQL Management Studio 2008? When I try to open it with SQL Management Studio 2008 I get the error:
Incompatible database version. What's wrong?
BUT When I create a new sdf database with SQL Management Studio 2008, I have no problem for open it again with SQL Management Studio 2008 but if I try to open it with WebMatrix it doesn't work...(server not found?)
View 1 Replies
Apr 11, 2010
I created and populated a database inside Visual Studio 2008 instead of using Management Studio.I need to run the script to create the schema for users and roles.The database does not show up in ASP.NET SQL Server Setup Wizard or in Management StudioThe only databases that do show up are master, model, msdb, and tempdb
Is there anything I can do to fix this or would it be easier for me to just create a new database starting in Management Studio and then connect to it from within Visual Studio?
View 4 Replies
Feb 2, 2010
Background: I use SQL server 2005 developer edition and visual studio 2008. Visual studio 2008 is running on a local machine with Vista business edition. SQL server is running on a remote server using Windows server 2003. Both computers are within the same domain.
Problem: First, I used the server explorer to connect to the SQL server. Everything works as desired. Then I write code to do the same thing. I keep getting the following error message:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 25 - Connection string is not valid)
However, I used the exactly identical connection string as the one used in the server explorer. So connection string should not be the problem. In addition, I tried the test code in MSDN, which tells whether my domainusername can flow the network. It turns out the user name is fine. I also went to the SQL server management studio and found the login for my computer is NVCWeihao while my computer login name is NVCweihao. I am wondering if this uppercase letter really affects the connection.
View 2 Replies
Feb 17, 2010
Using the Web Platform installer, in installed both the Visual Web Developer Express 2008 and SQL Server Management Studio Express 2008. Next, I connected to my local SQL Server Express 2008 and created a simple database and table using Visual Web Developer Express 2008 where the database file resided in the app data folder of my website. I can connect and explore the table from both Visual
Web Developer 2008 as well as the full blown version of Visual Studio 2008.
View 3 Replies
Jun 29, 2010
how can i transfer complete database from sql server 2008 to sql server 2008 without loosing relationship intigrity.
View 9 Replies
May 19, 2010
is there any difference between sql express and sql client. Actually I have been told to install a sql client using which i will connect to the sql server installed remotely. Also I have sql express edition 2008 installed on my machine. So is it the same. Will I be able to connect to the sql server using the sql server express edition.?
View 2 Replies
