MS SQL Server :: Install Issue Can't See T Server Management Studio

Cannot Connect To Sql Server Management Studio - SSL Issue?
We are working with a need to implement SSL and I used the IIS resource kits selfssl.exe tool to create a certification to test somethings on localhost. This worked well and I logged off, went home, logged back on from home via vnc and worked some more. No problems. I then logged off and called it a night. I did not uninstall the personall ssl certificate. At midnight, my machine reboots and defrags. Just including all the 'variables' I can think of. This morning I came into work and noticed that I could not successfully connect to the website. Then I noticed that I was not connecting to Sql Server. I got the error: A connection was successfully established with the server, but then an
error occurred during the pre-login handshake. (provider: Shared Memory
Provider, error: 0 - No process is on the other end of the pipe.) Okay. So I went to the event viewer and there was a new event, beginning after my reboot at midnight: A fatal error occurred when attempting to access the SSL server credential private key. The error code returned from the cryptographic module is 0x80090016. So I ran the certmgr.msc tool and removed the certificate from my personal folder. I still could not connect. Not after a reboot, not after stopping and restarting SQL Server, and not after removing the cert via IIS and stopping and restarting IIS.So I decided I would go to Management Studio and test the connection there. I could not connect via Management Studio! If anyone has an experience to lend here, I would be appreciative. Thank you.

View Replies ! View Related

SQL Server 2005 Management Studio Is Missing After Install
I have several servers that do not have SSMS installed. A couple of them are running as a clustered server. How do I install SSMS on these servers? they are running and have production databases on them. I have tried re-installing the management tools but that didn't work.

Any advice will be greatly appreciated.

View Replies ! View Related

Cannot Install SQL Server Management Studio Due To SPN Register Fail

I tried to install SQL Server 2005 in a fresh installed Windows 2003 SP2. And this server is a workgroup member, not a member of a domain.

The services (Database service, integration service, reporting services and so on) work fines, but the other components, such as SQL XML 6.0 , SQL Server management Studio cannot be installed. And I have tried several times on a fresh-installed windows 2003 sp2.

I checked the log, I found the following error,The SQL Network Interface library could not deregister the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b. Administrator should deregister this SPN manually to avoid client authentication errors.

2007-11-18 15:40:59.35 Server The SQL Network Interface library could not deregister the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b. Administrator should deregister this SPN manually to avoid client authentication errors.

Then the installation existed with the error message "There was an unexpected failure during the setup wizard. You may review the setup logs and/or click the help button for more information. ".

I never had this problem and this time, I really got the trouble and do not have solution.

Who have ever encounter this problem? Or someone can help me?

Thanks.

View Replies ! View Related

How To Install SQL Server Express Management Studio In Different Folder.
SSMSE installs itself in Program Files.

The installation program does not allow selecting a different folder.

This is a problem for me, I would like to install on a different drive.

Has anyone successfully moved SSMSE to a different folder, and how?

-apdil

View Replies ! View Related

SQL Server 2005 Management Studio On Vista Issue.
Here is my setup.

I have SQL Server 2005 Dev Edition with SP2 installed on Windows Vista Ultimate on my local computer.

I have a development cluster running 2000 as well as several production clusters running 2000. The production clusters are accessed through an encrytped tunnel.

The dilemna.

I am able to connect to the clusters fine. I am also able to access the each DB without incident. My problem comes when I try to connect to DB's with a large number of tables. DB's on the same clusters with around 20 tables come back fine. I am able to start to click on the views drill down and press the stop action and it will display a small list of views. The tables view however, goes into la la land.

My local Dev cluster has all the same DB's as my production clusters and has no problems returning the tables in any of the DB's.

I get an "IS BUSY: Micorsoft SQL Server Managment Studio is waiting for an internal operation to complete." error and the managment studio never completes.

Any help on this would be greatly appreciated.

View Replies ! View Related

Cannot Install SQL Server Management Studio After Removing Express Edition
I'm trying to upgrade my management studio to the full version, I uninstalled Express edition and started the install for the full version, but I get an error stating "you cannot install this component because it is already installed". I had a word with one of the guys in the office and he said the only way he's ever been able to get round this is by flattening the entire PC and starting again. Obviously I want to avoid that!

View Replies ! View Related

SQL Server 2005 64bit Install - Missing Management Studio
Good Afternoon,

I just installed SQL Server 2005 64bit on a fresh system with no other applications loaded on running on the new server.

The only other component that was installed with the SS2K5 database services is SSIS. The base installation and the SP2 patch went on perfect.

I went looking for the Management Studio thru the Start menu options and it is NOT under the Microsoft SQL Server 2005 group. The only options under the SS2K5 group are "Configuration Tools" and "Docs and Tutorials".

Here are file names that I downloaded from the MS website and installed.

SW CD SQL Svr Enterprise Edtn 2005 64Bit X64 English #1 x64 MLF.x11-57796 (which is a zipped)

SQLServer2005SP2-KB921896-x64-ENU

There was also another zipped file that I tried to install but it seems to be a duplicate of the zipped file above:

SW CD SQL Svr Enterprise Edtn 2005 64Bit X64 English #2 x64 MLF.x11-57797

Any help would be greatly appriciated.

Thanks ALL!

J Kusch

View Replies ! View Related

SQL SERVER 2005 Issue, Cannot Connect Using Management Studio Express
I am unable to connect to my database on a VPS server using server management studio express. I am able to ping the server. can connect to a local database but i have the same issue as others

Named Pipes Provider, error: 40 - Could not open a connection to SQL Server

have set the server so that it will allow remote connections and reset the server just to make sure that it has been implemented.

when i use osql in command prompt to make a test connection it tells me this

[SQL Native Client]Named Pipes Provider: Could not open a connection to SQL Server
[SQL Native Client]Login timeout expired
[SQL Native Client]An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.

on this forum it says to perform a ping and and an a ping a- to my server which does work.

Have been working on this for 3 days and can't figure it out.
Even had a guy in New Zealand who is usually my messiah of SQL and he can't figure it out so I'll be impressed if someone knows the answer.

I will buy a crate of beer for the person who solves this for me as this problem is costing me money! Maybe even 2 if done by end of tomorrow 6pm GMT!

If you don't want the beers, i will be more than happy to give a virtual pat on the back. :-)

If you need any more info, i will be watching this thread like a hawk so i'll happily answer any questions that you may have if i can.

Thanks in advance

View Replies ! View Related

Newbie Question- SQL Server 2005 Management Studio(how To Install SISS)

Hi all,

Im currently using SQL server 2005 Management Studio. I need to export files from SQL database to Access database.
But I dun think SISS is installed. Can anyone advise where to look for the file to install? Thks in advance.

Wee

View Replies ! View Related

How To Install Management Studio Express 2005 After VS2008 On Server 2008?
Ok so here's what happened:

Installed Server 2008 (64bit)
Installed VS2008 (+SQL 2005 Express, by default)

I've always installed SQL 2005 Dev (including the SQL Management Studio) before installing VS. Now I am trying to install just the management studio on this machine without success.

I tried installing the SQL workstation tools package from the SQL 2005 DVD but the installer detects the tools installed by SQL express (osql, etc.., but no management studio GUI) and the installer refuses to install anything else. I also tried downloading the separate installer for SQL management studio but it doesn't like something also: first thing the installer does is display this mesage:

"Installation of this product failed because it is not supported on this operating system For more information on supported configurations, see the product documentation."

Any way to do this without having to reinstall VS?

Thanks.

View Replies ! View Related

Can't Install 2005 SQL Server Management Studio, It Doesnt Show Up. What A Joke!

Hello I have wasted several hours on this simple problem and I'm ready to give up. I simply want SQL Server Management Studio on my laptop so I can connect to our 2005 servers and manage them. I have several different versions of 2005 from our MSDN subscription including but not limited to:

SQL 2005 Enterprise Edition (MSDN Library DVD)
SQL 2005 Workgroup Edition
SQL 2005 Standard Edition
Visual Studio 2005 Team Foundation Server (SQL Server 2005 Standard Edition)

Everytime I tried to install it, the Server Management Studio simply would not install. I looked for the exe files and didn't find them. I verified the path several times and they simply didn't install. I googled and found a few solutoins but none helped. For example on:
http://aspadvice.com/blogs/name/archive/2007/09/24/Installing-SQL-Server-Management-Studio-with-SQL-Server.aspx

They stated to go to the 'Tools' folder on the CD and run it from there, I do not have these folders on my SQL 2005 CD/DVDs. I tried to reinstall it a few times with selection only the management tools for the client, but it thinks I have SQL 2005 installed!!! I uninstalled it from add/remove, and it didn't work. I deleted the folders and it didn't work. I ran

msicuu2.exe and that still isn't working.

Are there ANY suggestions on how to get this freaking Server Management Studio installed? MS really blew it on this one. Thanks in advance.

View Replies ! View Related

What Is The Commad Prompt Option To Install SQL Server Management Studio Express
I am trying to install SQL Server 2005 using command prompt. I have gotten the latest download. My question is what is the commad prompt for the tag ADDLOCAL for SQL Server Management Studio Express. For SQL Server datatbase it is called SQL_Engine. In the same way what should I be using for "SQL Server Management Studio Express". I want to limit the choices that are installed on the user machines.

Any help is greatly appreciated.

Thanks,

Mahesh

View Replies ! View Related

How Can I Install SQL Server 2005 Developer Edition's Management Studio On A Desktop Machine?
I have installed Visual Studio 2005 Prof Edition on a Vista machine and SQL Server 2005 Developer Edition on a Windows 2000 server. They will be used as a development environment for us. As we need to management the SQL Server 2005, we would like to install the 2005 Developer SSMS on the Vista machine such that we can manage the SQL Server 2005 developer instance installed on that Win2k machine. However, the system does not allow us to do it. We have the express edition autoamtically installed while we installed the Vistual Studio. Is there any workaround that i can still install the 2005 developer SSMS without uninstall the sql server 2005 Xpress version? Or, I have to uninstall the Xpress version before i can install the 2005 developer's SSMS? Please help!

View Replies ! View Related

How Can I Re-install The Northwind Database In SQL Server Management Studio Express?Use SqlDataSet && The .Fill Method Properly?
Hi all,

In my VB 2005 Express, I created a Windowds Form application "shcDataSet" that used 1 SqlConnection, 1 SqlDataSet and 3 SqlDataAdapters associated with the Northwind Database in my SQL Server Management Studio Express. The SqlConnection had "User Instance" in the following ConnectionString: Data Source=.SQLEXPRESS;AttachDbFilename="C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataorthwnd.mdf";Integrated Security=True;Connect Timeout=30;User Instance=True. The 3 SqlDataAdapters were for the Northwind files "Customers", "Orders" and "Order Details" used in the SQLDataSet "AllOrders" with a AllOrders.xsd file. I ran the "shcDataSet" applicatyion and it worked fine. After the execution of "shcDataSet", I checked the Northwind database in my SQL Server Management Studio Express and clicked on "+" in front of Northwind database-I did not see any file showed up and I got the following error message: Failed to retrieve data for this request. (Microsoft.SqlServer.Express.SmoEnum) Additional information: one or more files do not match the primary file of the database. If you are attempting to attach a database, retry the operation with the correct files. If this is an existing database, the file may be corrupted and should be restored from a backup. (Microsoft SQL Server, Error:5173). If I executed the "shcDataSet" application again, I got a new error: SqlException was unhandled - Cannot open user default database. Login failed. Login failed for user 'myPC##myName' ------->daCustomers.Fill(AllOrders11, "Customers"). I have 3 questions to ask: (1) How can I re-install the Northwind database in SQL Server Management Studio Express? (2) When I use the .Fill Method, do I have to tell the SQL Server Management Studio Express to load and/or unload the Northwind files "Customers", "Orders" and "Order Details"? (3) After I executed the "shcDataSet", should I Upload the 3 Northwind files back to the SQL Server Management Studio Express? Please help and advise. Thanks, Scott Chang

View Replies ! View Related

How To Install Management Studio 2005

Hello:

I installed enterprise sql server 2005, sql server 2005 backward compatibility, aql server 2005 mobile(ENU) deverloper tools on the window XP. How to install 2005 management studio in this same machine?

Your help is highly apprecaited,

S

View Replies ! View Related

SQL Management Studio Install Problems
Hello,

I received the Visual Studio 2005 Standard and SQL Server 2005 Standard from the Microsoft Launch event in Anahiem. I was able to install SQL Express via VS 2005 without any problems. I am able to install SQL 2005 Standard without any problems the only problem I have is that I cannot install the Management Studio.

I uninstalled SQL Server 2005 Standard and installed the SQL Server 2005 Express managment studio and it installed without any problems. Is there any reason why I can install SSMSE but not SSMS?

Let me know what information you need besides what I have provided below.

Error message I recieve when trying to install Management Studio.EventType: sql90setup
P1: installtoolsaction.11
P2: 0x643
P3: sqls_installpackageaction_perform
P4: 0x643
P5: packageengine_installpackageaction.cpp@167
P6: setup.exe@2005.90.1399.0
P7: none

View Replies ! View Related

Help With Sql Management Studio Vista Install
I just recently purchased a sony with Vista business preloaded. It seems like it came with MS 2005 Sql Server but I'm not sure what edition. I went to the start menu to locate the Management Studio however the only option was the Configuration file. I went to MS site and downloaded the 2005 Sql Server Express Edition with Advance Service SP2 and it installed correctly. I believe this edition comes with Management Studio. However when I went to my Start Menu, the Management Studio file is still not there. How do I fix this problem? I am new to the MS Sql so a detail explanation will be appreciated. Thanks in advance.

View Replies ! View Related

SQL Server Management Studio Express: How Can I Install AdventureWorks &&"dbo&&" Files? Is AdventureWorksBI.msi Right For Them?
Hi all,

I downloaded the AdventureWorksDB.msi and install AdventureWorksDB in my C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData with

the following stuff:

AdventureWorks_Data

AdventureWorks_Log

masterlog

mastlog

model

modellog

.........

But, in my computerSQLEXPRESS (SQL Server 9.0...), I did not see the

following:

|-| Databases

|-| AdventureWorks

|+| Database Diagrams

|-| Tables

|+| System Tables

|+| dbo.Production.ProductCategory

|+| dbo.Production.Product

|+| ....................

Should I download the AdventureWorksBI.msi from Microsoft and install it to get the 'dbo' and other files? Please help and advise.

Thanks in advance,

Scott Chang

View Replies ! View Related

How Do You Install Management Studio On Full SQL Version
I've installed all the options from the sQL server CD but can't find how to install the Management Studio. I'm missing something obvious, but beat's me where it is.

TIA

View Replies ! View Related

Unable To Install Management Studio Express

I have full version of SQL server 2005 installed on my machine.

I am now also trying to install express edition as well. Though the database engine got installed, the managment studio *express* does not get installed as the management studio of full version is already installed. Can I use the management studio of full version to access this express edition database engine. If so how ?

View Replies ! View Related

Cannot Install Workstation Components (Management Studio,etc) (ADD_LOCAL Error)
I have Vista Ultimate (IIS Enabled), SQL Server 2005 Developer Edition
(downloaded and ran the SP2 Update), Visual Studio 2008. VS2008
installs no problem. When I install SQL Server 2005, I get an error
when it trys to install the last part( Workstation Components,
Management Studio, etc).
I have tried FULLY, MANUALLY removing all SQL products and registry
entries. I have used Windows Installer Cleanup Utility. I have tried
Microsoft's recommended way of manually removing SQL Server 2005.
If I manually run SqlRun_Tools.msi the error comes up right away.

The error is:
"A component that you have specified in the ADD_LOCAL property is
already
installed. To upgrade the existing component, refer to the
template.ini and
set the UPGRADE property to the name of the component."

Here's the Setup Error log: http://toby.pastebin.com/f63405e24
Any help?! Thanks!
-Toby

View Replies ! View Related

64 Bit Install Problems - Management Studio Expr && Advanced Services && Toolkit
Hi folks

I have a 64 bit Vista Home Premium PC SP1.

I downloaded and attempted to install the 64 bit version of SQL Express and I then got an error message to do with the ASP.NET Version registration requirement.

I then noticed a similar problem somebody else had & they solved it by doing the install/download as part of the Visual web Developer Expr installation - so I did the same. It seemed to work without any problems.

I had previously downloaded the 64 bit Management Studio Expr file, so after installing SQL server I attempted to install the management Studio program. Anyhow after starting the install program, I discovered that the instructions were either in Japanese or Chinese.

On the download page for SQL Server Express http://www.microsoft.com/express/sql/download/default.aspx, Under section 3 on the RHS it talks about Advanced Services & the Toolkit. Presumably, those downloads are for the 32 bit version, so is it possible to get a 64 bit version of Reporting Services & full-text search & the toolkit?

Anyway, if somebody could give me a bit of a clue I would really appreciate it.

Kind regards

Ross

View Replies ! View Related

Connection Issue With Enterprise Manager But Works With Management Studio
Hi,I have an interesting scenario. I have a SQL Server 2000 Standard Edition instance running on Computer A. I'm trying to access it through computers B and C.Computer B has Sql Server 2005 Express Edition installed and I was able to use its Management Studio and connect to instance on Computer A.Computer C has SQL Server 2000 Standard Edition installed. When I try to connect to the instance on Computer A, I get connection failed message.I checked some settings. Both TCP/IP and Named pipes are enabled on the instance in A. The TCP/IP port is set to 1433 for both client and server.Please give me some ideas as to how I can solve this problem. -Thanks

View Replies ! View Related

Install Visual Studio 2005 Rights Issue
Hello-

I am trying to install VS2005 Standard Edition on W2k Sp4. This install fails on the first part when MDAC 2.8 Sp1 tries to install. I am logged on as ADMINISTRATOR with admin rights. I tried to install MDAC 2.8 sp1 alone with the same result. Can you help?

Vincent DeLuca

vdeluca7@centurytel.net

View Replies ! View Related

Visual Studio Database File And SQL Server Management Studio Express Question
I have a database in my "App_Data" folder of my visual studio project. I can view it fine in Visual Studio's built-in tools for managing a database attached to a solution. However i recently started playing around with the SQL Server Management Studio Express program. When i attach my database to Management Studio, and try to run my program it crashes. I think it might be a permissions error?!? When i detatch it and reattach it in visual studio it runs fine again. Any suggestions? ThanksJason

View Replies ! View Related

SQL Server Management Express Studio Management Tools

I have recently installed the SQL Server Management Studio Express but I do not find Management Tools in order to create scheduled backups and shrinking of the databases. I was under the impression that this should be included in the Management Studio. I use the SQL 2005 Express for smaller customers who run the SQL on a desktop unit. I need a way to backup the data to a server machine for backup purposes. I have uninstalled and reinstalled to no avail.

View Replies ! View Related

Visual Studio 2005 Standard And SQL Server Management Studio?
I am new to visual studio and I am still not sure of all its components and features.

I installed visual studio 2005 standard edition but cannot find SQL Server Management Studio?

I guess this must be because it is not included with Visual studio 2005 standard. Is it included with VS 2005 professional?

I want to add pictures of products to my shopping site using an SQL database and Iâ€™ve been told that SQL Server Management studio is required as it is a graphical tool.

How would I go about obtaining the SQL server management studio. There seems to be different versions of SQL server that it is confusing to know which one to purchase.

Will the SQL server 2005 version that comes with Visual studio standard be sufficient for me now right? I want to create a shopping site with hundreds, perhaps even thousands of products. I want to use an SQL server 2005 database. The database will include â€˜dynamically generatedâ€™ product images if that is the correct terminology.

My goodness, it seems I still have so much to learn.

Thanks

View Replies ! View Related

How Do I Get The Database That I Am Using In Visual Studio Into My SQL Server Management Studio?
How do i get the database that i am using in visual studio into my SQL server management studio?
i need to create some scripts to create stored procedures on a live server.

View Replies ! View Related

Server Express, Management Studio Express, Visual Studio Standard, And An ASP.NET Page....
I believe I'm missing something as far as my configuration goes...I'm new to working with SQL server and the databinding I'm trying to do.

I have an ASP.NET page that has a radio button list box which I have databound to a database served up by SQL Express

I'm having a lot of problems with connections...

I was going to enumerate the behavior under each configuration (local only, remote tcp/ip only, remote pipes only, remote both), but I've realized that it is just flaky. Sometimes I can connect to the db with SQL Studio express, sometimes not. Sometimes I can add new tables and edit tables, sometimes not. Sometimes I can create a new connection when trying to databind from within Visual Studio, and sometimes not (sometimes I can't even connect, other times, I can connect initially but when I build a query through the designer it then has problems). Lastly, sometimes the ASP.NET page works correctly and sometimes not.

This all seems to be mostly independent of how I configure SQL Server as far as what kinds of connections are allowed. I thought there was a pattern, but as I tested it more rigorously I found there wasn't.

What I would like to do is be connected to the same DB with Visual Studio and SQL Studio, edit the DB as I wish, databind to it, and test my ASP.NET page, all without needing to jump through a bunch of hoops (although right now I wouldn't even know what those hoops are...it's just a shot in the dark as to what will work).

It's all quite maddening and any help would be appreciated.

View Replies ! View Related

About SQL Server Management Studio Help!!!
i have SQL Server 2005 dev edition and i wanted to use SQL Server Management Studio so is it installed or i need to install the SQL Server Management Studio express edition ???
thx

View Replies ! View Related

SQL Server Management Studio
Hey everyone,
Would someone please tell me why the new SQL Server Managment Studio comes with hardly not frills? What happened to the SQL Enterprise Manager in SQL Server 2000? It had DTS, SQL Agent Job and step viewing, Cool Wizards.. All that great stuff. but with this new Sql Server Management Studio with 2005 all I can do is pretty much look at the data and write queries and create and modify tables. Am I missing something?
I did download an external tool which was called an import/export wizard but it sucks compaired to the DTS in SQL 2000.
I did notice when I open my Sql Server Management Studio "Express" that it is the Express version... Is there a difference?
Thanks for any help.

View Replies ! View Related

SQL Server Management Studio
I have SQL server 2005 developer edition installed on my machine. I was expecting something like Enterprise manager to manage databases but nothing is installed by default. Ive found SQL server management studio express and installed it, but Ive also seen references to SQL Server Management Studio. Are there any differences between the two , or are they the same and are just described differently ?? Im a bit confused, Microsoft should make this clear.

View Replies ! View Related

SQL Server Management Studio
I have installed SQL Server Management Studio (for SQL2005) to a pc. When the user boots the pc, the following error is received:

fmaagent.exe - Common Language Runtime Debugging Services
Application has generated an exception that could not be handled.
Process id =0x328 (808), Thread id=0x32c (812).

Click Ok to terminate the application.
Click CANCEL to debug the application.

After clicking on OK, the pc continues on its merry way and boots up successfully.

Does anyone know what would cause this error? I have checked the Microsoft site but did not find this error listed among the documents.

The PC is running Windows XP.

Thanks in advance.

View Replies ! View Related

Sql Server Management Studio
In 2005 Query Analyzer no longer exists and the query is integrated with management studio. I have some users that want to query the database but I don' t want these users to have the ability to use anything else in the Management Studio - restore databases, detach, etc. Anyone have any ideas how this might be done? Thanks.

View Replies ! View Related

I Need SQL Server Management Studio!
Hi,

I have just completely installed MS SQL Server 2005 Express Edition in MS Server 2003.
After installation, I only have the Configuration Manager, Error and Usage Reporting and Surface Area Configuration, listed under Configuration Details.

SQL Server Management Studio is not accessible anywhere.
I also do not have the folder C:Program FilesMicrosoft SQL Server90ToolsBinnVSShell in which the SQL Server Management Studio is installed.
What must I do to get this component installed?

In this article http://msdn2.microsoft.com/en-us/library/ms143219.aspx, it is also written in step 8 that there should be a "Components to Install" page. I have done the installations and uninstallations a few times, but I still do not have "Components to Install" page. In fact, after step 7, I am brought to the "Features Selection" page.

What can I do to solve this problem? Please help.

Thanks.

View Replies ! View Related

SQL Server Management Studio
During SQL 2005 Standard edition the Management Studio did not install. how can I get it to install?

View Replies ! View Related

SQL Server Management Studio
I've install SQL Server 2005 Enterprise Evaluation Edition but the Management Studio was not installed. Is this normal? If yes how can I get the Management Studio

Thks

View Replies ! View Related

Where Is SQL Server Management Studio
I just had to do a total restore on one of my machines that has a copy of SQL Server 2005. Luckily, this is not the production server. But when I reinstalled SQL Server, I now do not have the option to get into SQL Server Management Studio. Why would this be?

Everything seemed to install okay - including Reporting Services.

Thanks for the information.

View Replies ! View Related

Where Is SQL Server Management Studio?
I have the "Ready to Launch" package, which includes Vidual Studio 2005 Standard Edition, SQL Server 2005 Standard Edition and something else called BizTalk Server 2006.

Anyway, Visual Studio is spread across two CD's and I have installed that. I now want to use the SQL Server Management Studio to administer a database I have running on a website. Anyway, SQL Server is on a DVD and when I put it into the drive it comes up with the autorun screen. I noticed that in the top left corner of this screen it says "SQL Server 2005 (Disc 1 of 2). However, there is no second disc, so I'm wondering if this is a problem or just a typo left over from the CD version.

There is two options in the menu under Install, "Server Components, tools, Books Online, and samples" and "Run the SQL Native Client Installation Wizard." I have tried both of these options and I still don't have the SQL Server Management Studio. In fact if I select the first option, when I get half way through the wizard, it asks what components I want installed. I cannot see any reference to the SQL Server Management Studio in this list, so I just select everything to be sure.

Once it has finsihed installing, all it does is create a Start Menu folder called "Microsoft SQL Server 2005" and another folder inside that called "Configuration Tools." This folder just contains a few things like configuration manager and surface area configuration, etc...

So where do I find this SQL Server Management Studio? Have I done something wrong or am I missing something (like a second disc)? I'm installing on to Windows XP, would that cause the problem? Do I need to be installing on to some sort of server OS (which I don't have BTW as I'm just a regular user looking for a way to administer my MS SQL database and I heard this tool was the way to go)?

View Replies ! View Related

SQL Server Management Studio
When attempting to start the SQL Server 2005 Management Studio from the Start Menu on my Windows 2003 SP1 server, I quickly get the error, "The Application failed to initialize properly (0x80000003). click on OK to erminate the application. I am accessing the server from my Windows XP Workstion using Timbuktu Pro Remote control software. I have no problem attaching to the SQL Server database on this server when connecting to it from my Workstation install of Management Studio. The SQL Server Business Intelligence Studio launches fine in the Timbuktu session as does SQL Server Configuration Manager. The Configuration manager shows all services (for both my Default and Named Instance) in the Running state.

Please help.

Rob

View Replies ! View Related