None of the Management Tools Installed...

I got SQL Server 2005 CTP (developer edition) as part of Visula Studio 2005 Beta Package. I removed all previous SQL server and Visual Studio stuff including all .NET framework versions completly. Then I installed SQL Server 2005 CTP first and selected all options (including all tools). I did not see any management tools (sql management studio or any other studio). I see all these cool services SQL Server, DTS, Reporting, Analysis etc., but no IDE to interact with what I can do with those services. Then I installed Visual Studio 2005 and it failed SQL Server Express which I do not want any way because I already installed SQL Server 2005. I am able to connect to SQL Server 2005 from Visual Studio, but lack of using real management tools makes all other services useless in SQL Server 2005. I tried to select those tools from advanced installation feature of SQL Server 2005 again and again... it gives error that I have not changed any installation changes and it can not install any tools. This is a mess. Can somebody explain what's going on here please... I greatly appreciate any help to make these tools appear.

Thanks
- KiranHi,
I had the same issue. Be sure that no express components are installed on your system. then uninstall sql server and reinstall it again. afterwards you should see the management tools. if you do not you should file a bug on product feedbakcenter about it.|||Thanks Ralph. As I mentioned, before installing SQL Server 2005, I removed everything related to either SQL Express components or VS or .NET I see in Add/Remove Software. Didn't work.|||In the setup directory on the installation CD there are several .MSI files.
I run SqlRun_Tools.msi and got the Mgmnt tools +

Non-Default SQL Server Port

Using Visual Studio .NET 2005 and I cannot make a database connection in sever explorer to a SQL server that listens on a non-default port. I can do this with VS .NET 2003, but not 2005. Please assist.Please help on this.|||

What is the version of the SQL Server?

Does the SQL Server and the connection application run on the same machine or on two different machines?

What protocols are enabled on the SQL Server?

What connection string does the application use?

Depending on your connection string you may need to start the SQL Browser service on the machine running SQL Server.

|||

SQL Server 2000
SQL Server 2000 and Visual Studio .NET 2005 are on seperate boxes.
SQL Server is listening on a non-default port (9696).
Just trying to connect to the database in server explorer.

No trusted SQl connection

Hello,
I am using the MSDE from Visual Studio.NET. I can access the SQL Server from
the server explorer only if I am logged into 2000 as administrator (I
installed MSDE using admin). If I try to connect from another login on the
same machine, I get the following error "Login failed. Not associated with a
trusted SQL Server connection". Any ideas?
Thanks,
Rick
hi Rick,
"rick_md" <rick_mc_806@.msn.com> ha scritto nel messaggio
news:CrqdnTC2aJqMiPLcRVn-qA@.comcast.com
> Hello,
> I am using the MSDE from Visual Studio.NET. I can access the SQL
> Server from the server explorer only if I am logged into 2000 as
> administrator (I installed MSDE using admin). If I try to connect
> from another login on the same machine, I get the following error
> "Login failed. Not associated with a trusted SQL Server connection".
> Any ideas?
that means that your non admin Windows account is not a regitered and
authorizated login to access SQL Server...
you have to log in as administrator and grant all non admin Windows account
privilege to access SQL Server
have a look at
http://support.microsoft.com/default...N-US;q325003#8
a good article about security you should read can be found at
http://support.microsoft.com/default...b;en-us;325022
we are here referring to Windows authentication...
if you like to log in in your MSDE instance using SQL Server authentication,
providing "User" and "pasword" credential, you have to modify the
authentication mode to Mixed mode..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply