Cant get diagrams to work in SQL Management Studio

I can't get diagrams to work in SQL Management Studio. When I try to open that folder in the object browser, I get:
"Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects."
That's great, but what exactly constitutes a "valid login" and who or what is it supposed to be?
If you follow the first set of steps, click the button with theellipsis next to the owner textbox, and you'll get a list of validlogins that you can choose an owner from. Then save it, andyou should be ready to go.
|||But other than myself (the one it's already set to), there are no otheraccounts other than system accounts. How is me being an owner not goodenough?
|||Huh. Well, if you go to the Security node for your SQL Serverinstance, and look at the Logins, is your account in there? If itis, and you're still getting the error, you might try changing the DBowner to another account, save it, and then change it back toyourself.
|||Tried all of the above. No joy. I am the owner, or so it says.
This is seriously annoying, and in true MS documentation fashion, the docs are not helpful.
|||Was this database by any chance restored from another machine? Maybe a machine on another domain? Or have there been changes tothe domain since the database was created? That's the last thingthat I can think of...That even though the account *looks* to be thesame on the surface, that underneath, it's got a different SID than theaccount that's been granted access to the SQL Server instance. Ifthat's the case, then the remedy would be to delete your accountentirely from list of the database's users, and then re-add it. If that's not the solution, hopefully someone else will have a tip,'cause I'm out of ideas.
|||The database was upgraded from the old 2000 Dev Edition to the 2005 DevEdition. I ended up scripting the database, nuking it, and recreatingit since there was nothing critical about the actual data. All is wellnow. It was still annoying. :)
|||

Solution, you need to go:

Properties of your database
Options
Compatibility level and here select SQL Server 2005
Click OK
Go to Database Diagrams and it will ask you if you want to create it , put yes and you will get your diagrams.
Hope it helps.
Sorry for my english im from Argentine.

|||I think it had to do with the compatibility level. I had the same with a restored 2000 database on 2005. Couldn't access the diagrams. But after setting the compatibility level (properties of database then the options page) to SQL Server 2005 (90), I was able to access them. (some didn't work though)
gr Rc

Can't find the server management studio

hey,

i did the installation, everything went well.

when i want to start the server management studio it isn't in the program files listed.

is there something i can do about it. i did the installation three times now and it didn't change a thing.

all comments are welcome

greetz

TjAnNeHi,

seems you did not insta′ll the client components. If you have another edition than SQL Server Express

(because this does not come with any clients components, unless you install the SQL Server Express Advanced Edition, but as for the non.-Advanced edition you can download the Express Management Studio from here: http://msdn.microsoft.com/vstudio/express/sql/download/)

you can simply rerun the installer and select the client components as well. If this does not solve the problem, please provide some more details about the edition of SQL Server and the SP level.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

During the setup screen process you can choose custom installation and select 'entire feature to be installed on hard drive'. That takes care the installation of required components of tools.

Also explain the steps you are taking to install the tools in this case.

|||I've the developper edition 2005

in fact there're no clients to check

service pack 2

where can i find these

TjAnNE|||the problem is solved
i installed the client and everything works fine,

thx for the tip

TjAnNesql

Cant find SQL Server Management Studio

I can't find theSQL Server Management Studio anywhere. I've installed SQL server 2005 developer edition and choosed every component from the list but it isn't in the start->program->SQL server 2005 menu, there's only a couple of configuration managers.

Where can I find it, or am I missing something?

Copy all the files to your hard drive and rerun setup and choose repair to select all components management studio is under management tools. And I don't know what the configuration managers do but they are not related to management studio. Hope this helps.

|||

or, tryhttp://www.microsoft.com/downloads/details.aspx?familyid=57856CDD-DA9B-4AD0-9A8A-F193AE8410AD&displaylang=en#filelist

where I googled it. Seems as it doesn't install in some packages of SQLExpress.

hope this helps. - itagens

Can't find SQL Profiler after Install

I have installed SQL Server Express, the configuration tools as well as the SQL Server Management Express However, I need the SQL Profiler. Where or how does this get installed with SQL Server Express?

hi,

Profiler does not come with SQLExpress... it' only available with full blown SQL Server 2005 editions, as reported in http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

regards

Can't find Report Builder

I've installed SQL Server 2005 Developer Edition along with Visual Studio 2005. The SQL management consol indicates that Reporting Services is running, but I can't seem to find the Report Builder for the life of me. Is it integrated into Visual Studio somewhere?Report Builder is a ClickOnce app that is installed and run from the web. If you go to the web interface for SSRS you should see a button towards the top of the web page that will launch Report Builder.sql

Can't find client

I can't see any SQL Management tools after installed SQL 2005. How can I see
the database by tools just like what we had in SQL 2000?
Hello,
Run the Setup program when you continue you have an option for Components to
install and choose "Workstation COmponents"
and continue.
Thanks
Hari
"Kit Wong" <Kit Wong@.discussions.microsoft.com> wrote in message
news:6CA37313-603E-4275-A714-E6491EA13408@.microsoft.com...
>I can't see any SQL Management tools after installed SQL 2005. How can I
>see
> the database by tools just like what we had in SQL 2000?
|||Hari,
Thanks. I can see and select workstation components and client components.
But it hhas been ceased with error immediately.
TITLE: Microsoft SQL Server 2005 Setup
There was an unexpected failure during the setup wizard. You may review the
setup logs and/or click the help button for more information.
For help, click:
[url]http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server& ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=50000& EvtType=packageengine%5cinstallpackageaction.cpp%4 0InstallToolsAction.10%40sqls%3a%3aInstallPackageA ction%3a%3aperform%400x643[/url]
BUTTONS:
OK
COACH [pizza01@.netvigator.com]
"Hari Prasad" wrote:

> Hello,
> Run the Setup program when you continue you have an option for Components to
> install and choose "Workstation COmponents"
> and continue.
> Thanks
> Hari
>
> "Kit Wong" <Kit Wong@.discussions.microsoft.com> wrote in message
> news:6CA37313-603E-4275-A714-E6491EA13408@.microsoft.com...
>
>
|||Hello,
See the Setup bootstap log folder (Program Files\Microsoft SQL
Server\90\Setup Bootstrap\LOG) for the setup log file and see if there is
any
error occured during installation.
Thanks
Hari
"Kit Wong" <KitWong@.discussions.microsoft.com> wrote in message
news:0BBA2865-ABD7-481B-9809-3FCC48D49193@.microsoft.com...[vbcol=seagreen]
> Hari,
> Thanks. I can see and select workstation components and client components.
> But it hhas been ceased with error immediately.
> TITLE: Microsoft SQL Server 2005 Setup
> --
> There was an unexpected failure during the setup wizard. You may review
> the
> setup logs and/or click the help button for more information.
>
> For help, click:
> [url]http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server& ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=50000& EvtType=packageengine%5cinstallpackageaction.cpp%4 0InstallToolsAction.10%40sqls%3a%3aInstallPackageA ction%3a%3aperform%400x643[/url]
> --
> BUTTONS:
> OK
> --
>
> COACH [pizza01@.netvigator.com]
> "Hari Prasad" wrote:

Can't execute sp in vb.net

Hellou
I'm trying to execute simple sp with 5 input parmeters from vb.net. This sp works great when it is run from SQL Server management studio, but when I want to execute it from vb.net, I allways get this error:
"Syntax error, permission violation, or other nonspecific error"
Here's the code:

Cnn.Open("...")

Comm.ActiveConnection = Cnn

Comm.CommandType = ADODB.CommandTypeEnum.adCmdStoredProc

Comm.CommandText = "spSklVnos-Prenos" 'that's thename of the sp

RetParam.Direction = ADODB.ParameterDirectionEnum.adParamOutput

RetParam.Type = ADODB.DataTypeEnum.adInteger

Comm.Parameters.Append(RetParam)

P1.Direction = ADODB.ParameterDirectionEnum.adParamInput

P1.Type = ADODB.DataTypeEnum.adVarChar

P1.Size = 1

P1.Value = LocParA

Comm.Parameters.Append(P1)

P2.Direction = ADODB.ParameterDirectionEnum.adParamInput

P2.Type = ADODB.DataTypeEnum.adInteger

P2.Value = LocPar1

Comm.Parameters.Append(P2)

P3.Direction = ADODB.ParameterDirectionEnum.adParamInput

P3.Type = ADODB.DataTypeEnum.adInteger

P3.Value = LocPar2

Comm.Parameters.Append(P3)

P4.Direction = ADODB.ParameterDirectionEnum.adParamInput

P4.Type = ADODB.DataTypeEnum.adInteger

P4.Value = LocPar3

Comm.Parameters.Append(P4)

P5.Direction = ADODB.ParameterDirectionEnum.adParamInput

P5.Type = ADODB.DataTypeEnum.adInteger

P5.Value = PrevzemIDx

Comm.Parameters.Append(P5)

Comm.Execute()

Am I missing something?
Thanks for any suggestion.
Dido

Your syntax looks fine to me, but I'm not a VB.NET expert. Make sure your datatypes for the parameters match the stored procedure exactly. You might try asking this question on the VB forums, since it doesn't seem to be related to SSIS.

Can't create databases in Management Studio

I seem to be having a number of problems using managment studio (MS) against my locally installed SQL 2005 Standard Edition. E.g. when I create a default database using MS it says...

TITLE: Microsoft SQL Server Management Studio

Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

The server could not load DCOM. (Microsoft SQL Server, Error: 7404)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=7404&LinkId=20476

However, the hyperlinks are less than helpful. I also get problems doing various maintance work from MS. I don't think its a database engine problem 'cause I can do all the work via TSQL DDL but the interface is so much easier to use (or should be). BTW it's running on XP Pro (firewall problem?).

I've also found an Event Log entry but don't know what it's asking me to enable...

Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17102
Date: 06/02/2006
Time: 20:12:06
User: N/A
Computer: TITAN
Description:
Failed to initialize Distributed COM (CoInitializeEx returned 80010119). Heterogeneous queries and remote procedure calls are disabled. Check the DCOM configuration using Component Services in Control Panel.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

|||

Finally sorted it out. It was the NVidia client to the motherboards Hardware Firewall that was causing the problem. I had to remove that to get IE7 working and now SQL Server is creating databases!

|||

I am getting all those exact same error messages when creating a database. My IE 7 is working just fine however. Can you tell me what you had to do to disable an nVidia motherboard hardware firewall thing? I've never heard of that, it sounds like it is worth a try at this point.

npack@.hotmail.com

|||Sure, you need to uninstall the nVidia firewall software.

Can't create databases in Management Studio

I seem to be having a number of problems using managment studio (MS) against my locally installed SQL 2005 Standard Edition. E.g. when I create a default database using MS it says...

TITLE: Microsoft SQL Server Management Studio

Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

The server could not load DCOM. (Microsoft SQL Server, Error: 7404)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=7404&LinkId=20476

However, the hyperlinks are less than helpful. I also get problems doing various maintance work from MS. I don't think its a database engine problem 'cause I can do all the work via TSQL DDL but the interface is so much easier to use (or should be). BTW it's running on XP Pro (firewall problem?).

I've also found an Event Log entry but don't know what it's asking me to enable...

Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17102
Date: 06/02/2006
Time: 20:12:06
User: N/A
Computer: TITAN
Description:
Failed to initialize Distributed COM (CoInitializeEx returned 80010119). Heterogeneous queries and remote procedure calls are disabled. Check the DCOM configuration using Component Services in Control Panel.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

|||

Finally sorted it out. It was the NVidia client to the motherboards Hardware Firewall that was causing the problem. I had to remove that to get IE7 working and now SQL Server is creating databases!

|||

I am getting all those exact same error messages when creating a database. My IE 7 is working just fine however. Can you tell me what you had to do to disable an nVidia motherboard hardware firewall thing? I've never heard of that, it sounds like it is worth a try at this point.

npack@.hotmail.com

|||Sure, you need to uninstall the nVidia firewall software.

Can't create a new publication

Hi,
I'm trying to create a publication in a SQL Server 2005 server. I
right clicked on Replication tab in management studio and selected
'New Publication'. The management studio waits for a long time and
then nothing happens. It does not start any 'New Publication' wizard
nor does it report any error. Could you please let me know if there
are any server settings that need to be enabled before configuring
Publications.
Thanks and Regards,
Thyagu.D
Does anything appear in the sql server log, or the windows log? What happens
if you run sp_adddistributor and sp_adddistributiondb directly?
Cheers,
Paul Ibison
|||You probably have some locking going on from a previous replication process.
Issue calls to sp_who2 or select * from sysprocesses where blocked<>0 order
by waittime desc to see if you can see these processes and kill them.
You might also want to try to create they publication by using replication
stored procedures.
Try sp_replicationdboption 'MyDatabase', 'published', true for a start.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Thyagu" <tdelli@.gmail.com> wrote in message
news:1184566869.270526.315190@.e16g2000pri.googlegr oups.com...
> Hi,
> I'm trying to create a publication in a SQL Server 2005 server. I
> right clicked on Replication tab in management studio and selected
> 'New Publication'. The management studio waits for a long time and
> then nothing happens. It does not start any 'New Publication' wizard
> nor does it report any error. Could you please let me know if there
> are any server settings that need to be enabled before configuring
> Publications.
> Thanks and Regards,
> Thyagu.D
>
|||On Jul 16, 2:14 pm, Paul Ibison <Paul.Ibi...@.Pygmalion.Com> wrote:
> Does anything appear in the sql server log, or the windows log? What happens
> if you run sp_adddistributor and sp_adddistributiondb directly?
> Cheers,
> Paul Ibison
This worked. Thanks!
Regards,
Thyagu.D

Can't connect using sa login and don't have any other administrator logins

I connected successfully in SQL Server Management studio using the 'sa' login and changed the authentication mode to Windows NT because I could not connect using my windows login but now I can't get any connection at all because 'sa' is no longer trusted.

I changed the loginmode registry setting to 2 and rebooted my PC but this has made no difference.

Can anyone help me get the 'sa' login back?

Unless you explicitly removed the default privileges (members of sysadmin) to builtin\Administrators, you should be able to connect to SQL Server using a Windows account that is member of the machine administrator s group.

NOTE: If you are using Windows Vista, you probably have UAC enabled, and you will need to use a full administrator token before connecting to SQL Server in the way I described above. You can use the right-click menu in Windows to “Run as Administrator” in order to get an unrestricted token before connecting to SQL Server.

Let us know if this information helped.

-Raul Garcia

SDE/T

SQL Server Engine

|||

I am on Windows XP, the engine is SQL Server 2000 and I am using SQL Server 2005 Management Studio. The problem started when I upgraded the software we are developing to the latest version which I suspect may have removed the existing SQL Server logins which did have full rights. It also changed the login mode from Windows Authentication to System Administration. My big mistake was to change the mode back to Windows Authentication in SQL Server Management Studio before checking the other logins and it was then that the problems started. My windows username has administrative rights but I still couldn't connect to the server using windows login.

I tried just now changing the LoginMode in the registry back to 1 and starting windows again but I still can't log in with 'sa'. I did notice that the default user registry key is set to 'guest' but don't know if that makes any difference.

I think that I may have to resort to re-installing SQL Server 2005. I would prefer not to do that but It doesn't really matter if I lose my local database as I do have a copy of it elsewhere.

Can you think of any other solutions?

|||

Try switching the LoginMode value in the registry to 2 (if I remember correctly, 2 should mean "Mixed mode"), restart SQL Server and try to connect with the SA login again.

-Raul Garcia

SDE/T

SQL Server Engine

|||

Thanks, that worked perfectly.

FYI...

The reason it didn't work the first time is that I changed it in registry key:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.2\MSSQLServer\LoginMode

which I assume is the key for SQL Server Management Studio 2005 but I didn't realise that there was another key, i.e.

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\LoginMode

which would be for the SQL Server 2000 engine.

Anyway, I have learned my lesson now and am going to add my windows login.

Can't connect using management studio while using remote desktop connection on lan.

I get the error message:

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.

I am not able to find this setting. Could someone please inform me of where to look and maybe what to do?

Thanks in advance.

Start/Programs/Microsoft SQL Server 2005/Configuration Tools/SQL Server Surface Area Configuration Manager/
Click Surface Area Configuration for Services and Connections
Click Database Engines / Remote connections
Select Local and Remote connections and one of the 3 choices below

also make sure the Allow Remote Connection to This Server option is checked on the
Server Properties/Connections page

|||

lkh wrote:

Start/Programs/Microsoft SQL Server 2005/Configuration Tools/SQL Server Surface Area Configuration Manager/
Click Surface Area Configuration for Services and Connections
Click Database Engines / Remote connections
Select Local and Remote connections and one of the 3 choices below

also make sure the Allow Remote Connection to This Server option is checked on the
Server Properties/Connections page

I have found the settings within the configuration tools up to the part where you mention the 3 choices below with success.

The part:
also make sure the Allow Remote Connection to This Server option is checked on the
Server Properties/Connections page

Is that from within the same configuration area or elsewhere?
Thanks so much.|||In Object Explorer in SQL Server Management Studio (SSMS) right click the server, click properties.|||

lkh wrote:

In Object Explorer in SQL Server Management Studio (SSMS) right click the server, click properties.

I'm sorry, there is nothing listed under object explorer pane. I see a default server under database engine in the registered servers pane.

Maybe because I haven't been able to connect yet? I'm not sure where else to look. I'm prolly goofed atm.

Maybe I'll have to do this the normal way and actually connect locally on that computer, then set that setting you mention.

I was hoping I could avoid having to do that, but I will if I have to.|||

right-click the default server, then click Connect/Object Explorer

SQL Server service also has to be started

|||Thanks so much for the help, the second part is already set to allow remote connections.
Turns out the problem I was having was due to my logging in as the second admin account on that pc. I could swear I installed it from that user account but it's acting like I can only connect to SQL via the original account on the pc.
Can't put my finger on it as it's been too long since the install.

Thanks for the help, all's good for now.|||Are you connecting with server\instance?

Can't connect to sql server 2005 after sysprep

I've installed sql2005 on win2k3, running on virtual pc... I can connect to
the sql server using sql server management studio... Because I'm building
base environment for testing, I seal the machine using sysprep. When I start
a new machine, I get this error...
"A connection was successfully established with the server, but then an
error occurred during the pre-login handshake. (provider: Shraed Memory
Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft
SQL Server, Error: 233)
Any idea how to solve this?
Best Regards,
Kit Kai
MVP (asp.net)
SgDotNet Council Member
Visit us @. http://www.sgdotnet.org
My Blog: http://community.sgdotnet.org/blogs/kitkaiHi Loke,
Welcome to use MSDN Managed Newsgroup!
From your descriptions, I understood you setup a machine with SQL Server
2005 and after using sysprep (something like GHOST, am I right?), the SQL
Server report the error message 233. If I have misunderstood your concern,
please feel free to point it out.
Since you are using sysprep, does the machine name remains the same? Please
perform the steps below and let me knwo whether it resolved your issue.
1. Open SQL Server Surface Area Configuration
Click 'Surface Area Configuration for Services and Connections'
Extend Database Engine and make sure Remote Connections is enabled for
both TCP/IP and named pipes.
2. Restart the SQL Server
3. Make sure the Firewall is configured correctly.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.|||Yup... You understood my problem perfectly.
In this case, the machine name remains the same, but this would be the only
case where the machine name remains the same... Basically, this setup will
be used as a base for other differentiating disk to build upon.
I've followed your steps, but the problem still remains. Firewall shouldn't
be the cause, since I'm still access sql using the same machine...
Best Regards,
Kit Kai
MVP (asp.net)
SgDotNet Council Member
Visit us @. http://www.sgdotnet.org
My Blog: http://community.sgdotnet.org/blogs/kitkai
"Michael Cheng [MSFT]" <v-mingqc@.online.microsoft.com> wrote in message
news:7nDahdh%23FHA.1236@.TK2MSFTNGXA02.phx.gbl...
> Hi Loke,
> Welcome to use MSDN Managed Newsgroup!
> From your descriptions, I understood you setup a machine with SQL Server
> 2005 and after using sysprep (something like GHOST, am I right?), the SQL
> Server report the error message 233. If I have misunderstood your concern,
> please feel free to point it out.
> Since you are using sysprep, does the machine name remains the same?
> Please
> perform the steps below and let me knwo whether it resolved your issue.
> 1. Open SQL Server Surface Area Configuration
> Click 'Surface Area Configuration for Services and Connections'
> Extend Database Engine and make sure Remote Connections is enabled for
> both TCP/IP and named pipes.
> 2. Restart the SQL Server
> 3. Make sure the Firewall is configured correctly.
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ========================================
=============
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Hi Kit,
This is a very strange issue. Unfortunately, I am afraid it is not
supported to install SQL Server 2005 like this due to license issues. Would
you please completely uninstall SQL Server 2005 and then reinstall it to
see whether you could login SQL Server 2005 this time?
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.|||Found the solution with Sukhdev's help.
Posted it @.
http://community.sgdotnet.org/blogs...2/13/23344.aspx
Best Regards,
Kit Kai
MVP (asp.net)
SgDotNet Council Member
Visit us @. http://www.sgdotnet.org
My Blog: http://community.sgdotnet.org/blogs/kitkai
"Michael Cheng [MSFT]" <v-mingqc@.online.microsoft.com> wrote in message
news:Tx%23OqCx%23FHA.3764@.TK2MSFTNGXA02.phx.gbl...
> Hi Kit,
> This is a very strange issue. Unfortunately, I am afraid it is not
> supported to install SQL Server 2005 like this due to license issues.
> Would
> you please completely uninstall SQL Server 2005 and then reinstall it to
> see whether you could login SQL Server 2005 this time?
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ========================================
=============
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Hi Kit,
Thanks so much for the update and share this invaluable experience here. I
believe other communities will also benefit much from this.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.

Can't connect to sql server 2005 after sysprep

I've installed sql2005 on win2k3, running on virtual pc... I can connect to
the sql server using sql server management studio... Because I'm building
base environment for testing, I seal the machine using sysprep. When I start
a new machine, I get this error...
"A connection was successfully established with the server, but then an
error occurred during the pre-login handshake. (provider: Shraed Memory
Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft
SQL Server, Error: 233)
Any idea how to solve this?
Best Regards,
Kit Kai
MVP (asp.net)
SgDotNet Council Member
Visit us @. http://www.sgdotnet.org
My Blog: http://community.sgdotnet.org/blogs/kitkai
Hi Loke,
Welcome to use MSDN Managed Newsgroup!
From your descriptions, I understood you setup a machine with SQL Server
2005 and after using sysprep (something like GHOST, am I right?), the SQL
Server report the error message 233. If I have misunderstood your concern,
please feel free to point it out.
Since you are using sysprep, does the machine name remains the same? Please
perform the steps below and let me knwo whether it resolved your issue.
1. Open SQL Server Surface Area Configuration
Click 'Surface Area Configuration for Services and Connections'
Extend Database Engine and make sure Remote Connections is enabled for
both TCP/IP and named pipes.
2. Restart the SQL Server
3. Make sure the Firewall is configured correctly.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Yup... You understood my problem perfectly.
In this case, the machine name remains the same, but this would be the only
case where the machine name remains the same... Basically, this setup will
be used as a base for other differentiating disk to build upon.
I've followed your steps, but the problem still remains. Firewall shouldn't
be the cause, since I'm still access sql using the same machine...
Best Regards,
Kit Kai
MVP (asp.net)
SgDotNet Council Member
Visit us @. http://www.sgdotnet.org
My Blog: http://community.sgdotnet.org/blogs/kitkai
"Michael Cheng [MSFT]" <v-mingqc@.online.microsoft.com> wrote in message
news:7nDahdh%23FHA.1236@.TK2MSFTNGXA02.phx.gbl...
> Hi Loke,
> Welcome to use MSDN Managed Newsgroup!
> From your descriptions, I understood you setup a machine with SQL Server
> 2005 and after using sysprep (something like GHOST, am I right?), the SQL
> Server report the error message 233. If I have misunderstood your concern,
> please feel free to point it out.
> Since you are using sysprep, does the machine name remains the same?
> Please
> perform the steps below and let me knwo whether it resolved your issue.
> 1. Open SQL Server Surface Area Configuration
> Click 'Surface Area Configuration for Services and Connections'
> Extend Database Engine and make sure Remote Connections is enabled for
> both TCP/IP and named pipes.
> 2. Restart the SQL Server
> 3. Make sure the Firewall is configured correctly.
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ================================================== ===
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
|||Hi Kit,
This is a very strange issue. Unfortunately, I am afraid it is not
supported to install SQL Server 2005 like this due to license issues. Would
you please completely uninstall SQL Server 2005 and then reinstall it to
see whether you could login SQL Server 2005 this time?
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Found the solution with Sukhdev's help.
Posted it @.
http://community.sgdotnet.org/blogs/.../13/23344.aspx
Best Regards,
Kit Kai
MVP (asp.net)
SgDotNet Council Member
Visit us @. http://www.sgdotnet.org
My Blog: http://community.sgdotnet.org/blogs/kitkai
"Michael Cheng [MSFT]" <v-mingqc@.online.microsoft.com> wrote in message
news:Tx%23OqCx%23FHA.3764@.TK2MSFTNGXA02.phx.gbl...
> Hi Kit,
> This is a very strange issue. Unfortunately, I am afraid it is not
> supported to install SQL Server 2005 like this due to license issues.
> Would
> you please completely uninstall SQL Server 2005 and then reinstall it to
> see whether you could login SQL Server 2005 this time?
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ================================================== ===
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
|||Hi Kit,
Thanks so much for the update and share this invaluable experience here. I
believe other communities will also benefit much from this.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.

Can't connect to Sql Server 2005

After install Sql Server 2005 as administrator, I enter in the computer as a
limited user. When I start the Management Studio I can't see any data base.
I checked that the service is started and I tried creating a new start
sesion with the name of the limited user in the domain (as I did in sql
server 2000) but it doesn't work.
What else can I do?
Thank you very much."alberto" <alberto@.nospam.es> wrote in message
news:O4JyJ5hSHHA.1036@.TK2MSFTNGP03.phx.gbl...
> After install Sql Server 2005 as administrator, I enter in the computer as
> a limited user. When I start the Management Studio I can't see any data
> base. I checked that the service is started and I tried creating a new
> start sesion with the name of the limited user in the domain (as I did in
> sql server 2000) but it doesn't work.
> What else can I do?
Log into SQL Server as an administrator and create a login for your limited
user, assigning that user either server roles, or database access as
appropriate.
David|||I just did it but I still can't connect. As limited user I don't see any
server.
"David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> escribió en el
mensaje news:OubC9BiSHHA.3980@.TK2MSFTNGP02.phx.gbl...
>
> "alberto" <alberto@.nospam.es> wrote in message
> news:O4JyJ5hSHHA.1036@.TK2MSFTNGP03.phx.gbl...
>> After install Sql Server 2005 as administrator, I enter in the computer
>> as a limited user. When I start the Management Studio I can't see any
>> data base. I checked that the service is started and I tried creating a
>> new start sesion with the name of the limited user in the domain (as I
>> did in sql server 2000) but it doesn't work.
>> What else can I do?
>
> Log into SQL Server as an administrator and create a login for your
> limited user, assigning that user either server roles, or database access
> as appropriate.
> David|||"alberto" <alberto@.nospam.es> wrote in message
news:#KRbFOiSHHA.5068@.TK2MSFTNGP03.phx.gbl...
>I just did it but I still can't connect. As limited user I don't see any
>server.
>
Can't see it? or can't connect? What are you entering in the "server name"
box in the SQL Server Management Studio connect dialog? What error message
are you getting?
David|||In the combo box of servers I don't see anything.
"David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> escribió en el
mensaje news:%23r3b$biSHHA.5068@.TK2MSFTNGP03.phx.gbl...
>
> "alberto" <alberto@.nospam.es> wrote in message
> news:#KRbFOiSHHA.5068@.TK2MSFTNGP03.phx.gbl...
>>I just did it but I still can't connect. As limited user I don't see any
>>server.
> Can't see it? or can't connect? What are you entering in the "server
> name" box in the SQL Server Management Studio connect dialog? What error
> message are you getting?
> David|||"alberto" <alberto@.nospam.es> wrote in message
news:##3e2fiSHHA.192@.TK2MSFTNGP04.phx.gbl...
> In the combo box of servers I don't see anything.
>
Then type in the name of the server, or if you are on the same box, type
'(local)'. If you installed a named instance add the instance name.
Default Instance:
MyServer
(local)
Named instance (called MyInstance)
MyServer\MyInstance
(local)\MyInstance
David

Can't connect to Sql Server 2005

After install Sql Server 2005 as administrator, I enter in the computer as a
limited user. When I start the Management Studio I can't see any data base.
I checked that the service is started and I tried creating a new start
sesion with the name of the limited user in the domain (as I did in sql
server 2000) but it doesn't work.
What else can I do?
Thank you very much."alberto" <alberto@.nospam.es> wrote in message
news:O4JyJ5hSHHA.1036@.TK2MSFTNGP03.phx.gbl...
> After install Sql Server 2005 as administrator, I enter in the computer as
> a limited user. When I start the Management Studio I can't see any data
> base. I checked that the service is started and I tried creating a new
> start sesion with the name of the limited user in the domain (as I did in
> sql server 2000) but it doesn't work.
> What else can I do?
Log into SQL Server as an administrator and create a login for your limited
user, assigning that user either server roles, or database access as
appropriate.
David|||I just did it but I still can't connect. As limited user I don't see any
server.
"David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> escribi en el
mensaje news:OubC9BiSHHA.3980@.TK2MSFTNGP02.phx.gbl...
>
> "alberto" <alberto@.nospam.es> wrote in message
> news:O4JyJ5hSHHA.1036@.TK2MSFTNGP03.phx.gbl...
>
> Log into SQL Server as an administrator and create a login for your
> limited user, assigning that user either server roles, or database access
> as appropriate.
> David|||"alberto" <alberto@.nospam.es> wrote in message
news:#KRbFOiSHHA.5068@.TK2MSFTNGP03.phx.gbl...
>I just did it but I still can't connect. As limited user I don't see any
>server.
>
Can't see it? or can't connect? What are you entering in the "server name"
box in the SQL Server Management Studio connect dialog? What error message
are you getting?
David|||In the combo box of servers I don't see anything.
"David Browne" <davidbaxterbrowne no potted meat@.hotmail.com> escribi en el
mensaje news:%23r3b$biSHHA.5068@.TK2MSFTNGP03.phx.gbl...
>
> "alberto" <alberto@.nospam.es> wrote in message
> news:#KRbFOiSHHA.5068@.TK2MSFTNGP03.phx.gbl...
> Can't see it? or can't connect? What are you entering in the "server
> name" box in the SQL Server Management Studio connect dialog? What error
> message are you getting?
> David|||"alberto" <alberto@.nospam.es> wrote in message
news:##3e2fiSHHA.192@.TK2MSFTNGP04.phx.gbl...
> In the combo box of servers I don't see anything.
>
Then type in the name of the server, or if you are on the same box, type
'(local)'. If you installed a named instance add the instance name.
Default Instance:
MyServer
(local)
Named instance (called MyInstance)
MyServer\MyInstance
(local)\MyInstance
David

Can''t connect to SQL Reporting Services through IIS and SQL Server Management Studio

Hi,

I'm getting the following error message when I want to connect to reporting services through SQL Server Management Studio. I have also check the reporting services configurations manager for any issues but still can't connect. The http://localhost/reportserver also is down. I also checked if ASPNET account belongs to the Reporting Services security settings and it does. IIS is up and running.

I'm running SQL 2005 Enterprise 64bit with Service Pack 2.

===================================

Cannot connect to ctbbcysql02.

===================================

The request failed with HTTP status 503: Service Unavailable. (Microsoft.SqlServer.Management.UI.RSClient)

Program Location:

at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)
at Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
at Microsoft.SqlServer.Management.UI.RSClient.RSClientConnection.CreateConnection(String connectionString)
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.CreateConnectionObject()
at Microsoft.SqlServer.Management.UI.RSClient.RSConnectionInfo.RSTypeImpl.GetConnectionObject(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.RSType.GetConnectionObject(UIConnectionInfo ci)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

Any help will be greatly appreciated.

Regards,

Ruaan

RuaanD79 wrote:

I'm getting the following error message when I want to connect to reporting services through SQL Server Management Studio. The http://localhost/reportserver also is down.

That would be why you can't connect to it. What indicates to you that the report server is down? Is it really down or you just can't connect to it?

What, if anything, is not checked on the Reporting Services Configuration Tool?

Cant connect to SQL 2005 Express with SQL Server Management Studio Express

I've seen the following error posted when people try to connect to their server via their applications but didn't see anyone having problems when trying to connect with SQL Server Management Studio Express. Am I missing something here? This is the error:

<<
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. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)(Microsoft SQL Server, Error: 2)
>
The server is not remote so I don't see why I need to enable remote connection. I am also using the default connection settings.

Are U using 'Windows Authentication' or SQL Server Auth?

While trying to login as 'sa' on my SQLServ2005 Express, I'm getting a bunch of errors like...

Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452)

No idea why !!!

I thought 'sa' was the ultimate super-user login. If 'sa' is not a trusted connection, then who is... sounds like a big joke !!

|||

I figured out the solution to my problem. By default, the Server Managaement Studio tried to connect to my computer name. It turns out when you install SQL 2000 Express, the default instance name is SQLEXPRESS. So when connecting, I just changed the server name to <computer name>\SQLEXPRESS and it worked!

As to your problem BugSlayer, I have seen that error before. It was due to the fact that the server was configured to allow only windows authentication. It has to be set to "mixed authentication" or "both windows and sql authentication" (I forget what the exact words were). I tried to look for the setting but couldn't find it. I set mine explicitly during installation. Hope that helps.

|||

Thanks NthPixel.

Actually my installation of SQL 2005 Express was an accident waiting to happen. I had installed on top of an existing MSDE (from VS 7.0) and for reasons unknown the 'sa' account was locked out PLUS built-in/Administrators did not have any grant rights. A classic catch-22 situation !!

Had to uninstall both SQLExpr & MSDE and reinstall SQLExpr with mixed auth mode this time, and now I'm able to use both types of authentications. Although our symptons match, the problem on my machine basically arised from upgrading MSDE to SQLServer 2005 Express.

If any of U have such a setup, please remove and simplify it before it blows up in to a massive disaster at some future critical juncture.

Can't connect to server using server management studio

Hi,
For some reason I can't connect to a (remote) SQL server using SQL server
management studio (2005) from my local SQL 2005 Server. I can connect from
numerous other PCs/Servers in my site except this one. The local SQL Server
is running Windows 2003 R2.
It will accept the username (sa) and password and just hang there. It then
pops up the error:
"is Busy
Microsoft SQL Server Management Studio is waiting for an internal operation
to complete."
Then after a while it will fail with the error:
"An exception occurred while executing a transact-sql statement or batch.
Additional information:-
A transport level error has occured when receiving results from the server"
I have checked the network setup and there are definately no firewall or
routing issues (after all you can log on - if you get the password wrong it
tells you), plus several other PCs/Servers at this site can access the
server with no problems at all. There is no firewall on the local server.
Can anyone shed any light on this? Any help much appreciated.
Thanks in advance,
-H
Can you connect to the SQL instance from that client machine at all, I mean,
if you try a different tool such as osql.exe? That should help narrow the
scope of the problem.
Linchi
"Hooopla" wrote:

> Hi,
> For some reason I can't connect to a (remote) SQL server using SQL server
> management studio (2005) from my local SQL 2005 Server. I can connect from
> numerous other PCs/Servers in my site except this one. The local SQL Server
> is running Windows 2003 R2.
> It will accept the username (sa) and password and just hang there. It then
> pops up the error:
> "is Busy
> Microsoft SQL Server Management Studio is waiting for an internal operation
> to complete."
> Then after a while it will fail with the error:
> "An exception occurred while executing a transact-sql statement or batch.
> Additional information:-
> A transport level error has occured when receiving results from the server"
> I have checked the network setup and there are definately no firewall or
> routing issues (after all you can log on - if you get the password wrong it
> tells you), plus several other PCs/Servers at this site can access the
> server with no problems at all. There is no firewall on the local server.
> Can anyone shed any light on this? Any help much appreciated.
> Thanks in advance,
> -H
>
>
|||I'm afraid osql times out aswell. I'm also trying to use a third party
package and that has the same problem
-H
"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:A8EC5A0C-2158-480C-8D38-3D38145577A7@.microsoft.com...[vbcol=seagreen]
> Can you connect to the SQL instance from that client machine at all, I
> mean,
> if you try a different tool such as osql.exe? That should help narrow the
> scope of the problem.
> Linchi
> "Hooopla" wrote:
|||FYI I can remote desktop successfully to the remote server.
"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:A8EC5A0C-2158-480C-8D38-3D38145577A7@.microsoft.com...[vbcol=seagreen]
> Can you connect to the SQL instance from that client machine at all, I
> mean,
> if you try a different tool such as osql.exe? That should help narrow the
> scope of the problem.
> Linchi
> "Hooopla" wrote:

Can't connect to server using server management studio

Hi,
For some reason I can't connect to a (remote) SQL server using SQL server
management studio (2005) from my local SQL 2005 Server. I can connect from
numerous other PCs/Servers in my site except this one. The local SQL Server
is running Windows 2003 R2.
It will accept the username (sa) and password and just hang there. It then
pops up the error:
"is Busy
Microsoft SQL Server Management Studio is waiting for an internal operation
to complete."
Then after a while it will fail with the error:
"An exception occurred while executing a transact-sql statement or batch.
Additional information:-
A transport level error has occured when receiving results from the server"
I have checked the network setup and there are definately no firewall or
routing issues (after all you can log on - if you get the password wrong it
tells you), plus several other PCs/Servers at this site can access the
server with no problems at all. There is no firewall on the local server.
Can anyone shed any light on this? Any help much appreciated.
Thanks in advance,
-HCan you connect to the SQL instance from that client machine at all, I mean,
if you try a different tool such as osql.exe? That should help narrow the
scope of the problem.
Linchi
"Hooopla" wrote:

> Hi,
> For some reason I can't connect to a (remote) SQL server using SQL server
> management studio (2005) from my local SQL 2005 Server. I can connect from
> numerous other PCs/Servers in my site except this one. The local SQL Serve
r
> is running Windows 2003 R2.
> It will accept the username (sa) and password and just hang there. It then
> pops up the error:
> "is Busy
> Microsoft SQL Server Management Studio is waiting for an internal operatio
n
> to complete."
> Then after a while it will fail with the error:
> "An exception occurred while executing a transact-sql statement or batch.
> Additional information:-
> A transport level error has occured when receiving results from the server
"
> I have checked the network setup and there are definately no firewall or
> routing issues (after all you can log on - if you get the password wrong i
t
> tells you), plus several other PCs/Servers at this site can access the
> server with no problems at all. There is no firewall on the local server.
> Can anyone shed any light on this? Any help much appreciated.
> Thanks in advance,
> -H
>
>|||I'm afraid osql times out aswell. I'm also trying to use a third party
package and that has the same problem
-H
"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:A8EC5A0C-2158-480C-8D38-3D38145577A7@.microsoft.com...[vbcol=seagreen]
> Can you connect to the SQL instance from that client machine at all, I
> mean,
> if you try a different tool such as osql.exe? That should help narrow the
> scope of the problem.
> Linchi
> "Hooopla" wrote:
>|||FYI I can remote desktop successfully to the remote server.
"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:A8EC5A0C-2158-480C-8D38-3D38145577A7@.microsoft.com...[vbcol=seagreen]
> Can you connect to the SQL instance from that client machine at all, I
> mean,
> if you try a different tool such as osql.exe? That should help narrow the
> scope of the problem.
> Linchi
> "Hooopla" wrote:
>