Showing posts with label machine. Show all posts
Showing posts with label machine. Show all posts

Thursday, March 29, 2012

Can't connect from a vista client to SQL 2005 box,other machines work fine

Hey. I've a windows vista machine which can't connect to SQL 2005 box. Other machines which are lower than vista work fine. Also, vista box can connect to other SQL 2005 instances but can't connect to only one instance. But, I can connect to the instance fine from my XP box. Also, it's not a permissions issue. This user is an SA and can connect form some other machine. SQL 2005 box is at 2047 version right now. And, the user is able to connect to some other boxes which are also at 2047. Please help. Thank you

Add the account sepcifically to the SQL Server. When you connect from Vista (because of the UAC) it strips out your group SID from local admins, so SQL Server doesn't know who you are, and that's probably what is causing your issue. Add the user's account by name to the box.

If this post answers your question, make sure you mark it "answered" so others can find it quickly.

Thanks -

Buck Woody
http://www.buckwoody.com

Can't Connect

I have just installed Sql server 2005 on my Win XP Pro machine.
When I go into the sql server management studio, there is only
one entry under the "database engine" entry in the registered servers'
panel on the left. It is MyServerName\SQLEXPRESS.
When I click on it and then select connect, either new query
or object explorer, I get one of the following errors.
An error has occurred while establishing a connection to there server.
When connecting to SQL Server 2005, the failure may be caused by the
fact that under the default settings SQL Server does not allow remote
connections. (Provider : Sql Network interfaces, error: 26 - Error locating
Server/Instance Specified )
An error has occurred while establishing a connection to there server.
When connecting to SQL Server 2005, the 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.
I have looked all over the internet, but couldn't find anything that
would help.
I went into the sql server configuration manger, and enabled the name
pipes and rebooted.
I didn't work. In the sql service configuration manager I have five
services that are status of
running and startup mode of automatic. However they are not for the
SQLExpress server.
They are for another sql server name, that I put in for the server name
when I installed
sql server 2005. I thought that would be the server name.
There are two entries under sql server 2005 network configuration
Protocals for SQLEXPRESS and
Protocals for Myotherservername
How can I connect.
Why do I have two instances are those instances of servers,
I thought that there was only server.
What do I do?
Thanks in Advance,
Laurence
I suggest starting with my blog entry on connecting. Just search
www.betav.com/blog/billva. There are several relevant articles there.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
------
"Larry" <NoSpam@.Something.com> wrote in message
news:e5O9nLU3HHA.5316@.TK2MSFTNGP04.phx.gbl...
>I have just installed Sql server 2005 on my Win XP Pro machine.
> When I go into the sql server management studio, there is only
> one entry under the "database engine" entry in the registered servers'
> panel on the left. It is MyServerName\SQLEXPRESS.
> When I click on it and then select connect, either new query
> or object explorer, I get one of the following errors.
> An error has occurred while establishing a connection to there server.
> When connecting to SQL Server 2005, the failure may be caused by the
> fact that under the default settings SQL Server does not allow remote
> connections. (Provider : Sql Network interfaces, error: 26 - Error
> locating
> Server/Instance Specified )
> An error has occurred while establishing a connection to there server.
> When connecting to SQL Server 2005, the 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.
> I have looked all over the internet, but couldn't find anything that would
> help.
> I went into the sql server configuration manger, and enabled the name
> pipes and rebooted.
> I didn't work. In the sql service configuration manager I have five
> services that are status of
> running and startup mode of automatic. However they are not for the
> SQLExpress server.
> They are for another sql server name, that I put in for the server name
> when I installed
> sql server 2005. I thought that would be the server name.
> There are two entries under sql server 2005 network configuration
> Protocals for SQLEXPRESS and
> Protocals for Myotherservername
>
> How can I connect.
> Why do I have two instances are those instances of servers,
> I thought that there was only server.
> What do I do?
> Thanks in Advance,
> Laurence
>
>
>
>
|||Thank You.
William Vaughn wrote:
> I suggest starting with my blog entry on connecting. Just search
> www.betav.com/blog/billva. There are several relevant articles there.
>
sql

Can't Connect

I have just installed Sql server 2005 on my Win XP Pro machine.
When I go into the sql server management studio, there is only
one entry under the "database engine" entry in the registered servers'
panel on the left. It is MyServerName\SQLEXPRESS.
When I click on it and then select connect, either new query
or object explorer, I get one of the following errors.
An error has occurred while establishing a connection to there server.
When connecting to SQL Server 2005, the failure may be caused by the
fact that under the default settings SQL Server does not allow remote
connections. (Provider : Sql Network interfaces, error: 26 - Error locating
Server/Instance Specified )
An error has occurred while establishing a connection to there server.
When connecting to SQL Server 2005, the 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.
I have looked all over the internet, but couldn't find anything that
would help.
I went into the sql server configuration manger, and enabled the name
pipes and rebooted.
I didn't work. In the sql service configuration manager I have five
services that are status of
running and startup mode of automatic. However they are not for the
SQLExpress server.
They are for another sql server name, that I put in for the server name
when I installed
sql server 2005. I thought that would be the server name.
There are two entries under sql server 2005 network configuration
Protocals for SQLEXPRESS and
Protocals for Myotherservername
How can I connect.
Why do I have two instances are those instances of servers,
I thought that there was only server.
What do I do?
Thanks in Advance,
LaurenceI suggest starting with my blog entry on connecting. Just search
www.betav.com/blog/billva. There are several relevant articles there.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
----
---
"Larry" <NoSpam@.Something.com> wrote in message
news:e5O9nLU3HHA.5316@.TK2MSFTNGP04.phx.gbl...
>I have just installed Sql server 2005 on my Win XP Pro machine.
> When I go into the sql server management studio, there is only
> one entry under the "database engine" entry in the registered servers'
> panel on the left. It is MyServerName\SQLEXPRESS.
> When I click on it and then select connect, either new query
> or object explorer, I get one of the following errors.
> An error has occurred while establishing a connection to there server.
> When connecting to SQL Server 2005, the failure may be caused by the
> fact that under the default settings SQL Server does not allow remote
> connections. (Provider : Sql Network interfaces, error: 26 - Error
> locating
> Server/Instance Specified )
> An error has occurred while establishing a connection to there server.
> When connecting to SQL Server 2005, the 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.
> I have looked all over the internet, but couldn't find anything that would
> help.
> I went into the sql server configuration manger, and enabled the name
> pipes and rebooted.
> I didn't work. In the sql service configuration manager I have five
> services that are status of
> running and startup mode of automatic. However they are not for the
> SQLExpress server.
> They are for another sql server name, that I put in for the server name
> when I installed
> sql server 2005. I thought that would be the server name.
> There are two entries under sql server 2005 network configuration
> Protocals for SQLEXPRESS and
> Protocals for Myotherservername
>
> How can I connect.
> Why do I have two instances are those instances of servers,
> I thought that there was only server.
> What do I do?
> Thanks in Advance,
> Laurence
>
>
>
>|||Thank You.
William Vaughn wrote:
> I suggest starting with my blog entry on connecting. Just search
> www.betav.com/blog/billva. There are several relevant articles there.
>

Tuesday, March 27, 2012

Can't Attach to DB File using SSMS

Hi all,

I have "SQL Server Express" as well as SSMS-E installed on the same machine. I am trying to get SSMS-E to connect to a database (i.e., an .MDF file) that resides in a folder on the desktop.

After establishing a connection to my "SQL Server Express" instance within SSMS-E, I right-click on "Databases", in the "Object Explorer" window and select "Attach..." and click the "Add..." button. The resulting dialog box opens in the directory:
"C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data" where I see several MDF files. But as I said, my MDF is not in this directory - it's on the desktop.

If I try to navigate to the proper directory on the desktop I see no MDF files. In fact, I cannot even navigate past my username -- that is, I cannot even navigate to the desktop, let alone folders on the desktop. I don't know why.

Of course I *could* put the MDF file in the SQL-E approved directory but shouldn't I just be able to navigate to it using SSMS-E? Incidentally, I *AM* able to connect to the database on my desktop if I use Visual Studio and I specify "UserInstance=true". Not specifying "UserInstance=true" results in this error:

An attempt to attach an auto-named database for file C:\Documents and Settings\Robin\Desktop\MyCompany.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

Can someone explain what might be causing the problem with SSMS-E, and, for that matter, why it's necessary to specify "UserInstance=true" in Visual Studio?

Thanks so much. I hope these are not too many questions.

Robin

You are attempting to attach a file that is located in a 'protected' storage area -specifically your private 'Desktop'. That file would not be available to other users of the computer. You can attach it to a user instance since that user instance will be restricted for your use only and other users could not access it.

If you want to attach the file to the server, move the file from your 'Desktop' to a storage area accessible for all users of SQL Server.

Sunday, March 25, 2012

Can't attach db - says read-only

Hi all,
SQL novice here.
I had a SQL Server 2000 machine that died, but it had some
data I need, so i pulled the drive, found the SQL data folder
and copied it to a network location.
On my SQL Server 2003 machine runnig SQL Server Express, I
right click on Databases, select Attach, point to the database
I want, and the process fials saying the data is read-only, make
it read write and try again.
Problem is, the files are not read-only. I checked and reset
them several times, and each attempt fails with the same message.
How can I attach this database to my sql server?
Thanks,
kpg
There is a article on Microsoft's web site that briefly discusses this issue
on SQL 2005 Express:
http://msdn2.microsoft.com/en-us/library/bb264564.aspx
If you've already checked the permissions on the file, see if you can check
the permissions you have on the database server and folder where the file is
being written to. Your permissions may be different than what they were on
the original DB server.
"kpg*" wrote:

> Hi all,
> SQL novice here.
> I had a SQL Server 2000 machine that died, but it had some
> data I need, so i pulled the drive, found the SQL data folder
> and copied it to a network location.
> On my SQL Server 2003 machine runnig SQL Server Express, I
> right click on Databases, select Attach, point to the database
> I want, and the process fials saying the data is read-only, make
> it read write and try again.
> Problem is, the files are not read-only. I checked and reset
> them several times, and each attempt fails with the same message.
> How can I attach this database to my sql server?
> Thanks,
> kpg
>
|||> There is a article on Microsoft's web site that briefly discusses this
> issue on SQL 2005 Express:
> http://msdn2.microsoft.com/en-us/library/bb264564.aspx
> If you've already checked the permissions on the file, see if you can
> check the permissions you have on the database server and folder where
> the file is being written to. Your permissions may be different than
> what they were on the original DB server.
Thank you * 100!
I copied the db file into the data folder of the sql 2005 instance
and yes, I was able to attach it. So it was a folder permission
issue.
Thanks again!
kpg
sql

Can't attach db - says read-only

Hi all,
SQL novice here.
I had a SQL Server 2000 machine that died, but it had some
data I need, so i pulled the drive, found the SQL data folder
and copied it to a network location.
On my SQL Server 2003 machine runnig SQL Server Express, I
right click on Databases, select Attach, point to the database
I want, and the process fials saying the data is read-only, make
it read write and try again.
Problem is, the files are not read-only. I checked and reset
them several times, and each attempt fails with the same message.
How can I attach this database to my sql server?
Thanks,
kpgThere is a article on Microsoft's web site that briefly discusses this issue
on SQL 2005 Express:
http://msdn2.microsoft.com/en-us/library/bb264564.aspx
If you've already checked the permissions on the file, see if you can check
the permissions you have on the database server and folder where the file is
being written to. Your permissions may be different than what they were on
the original DB server.
"kpg*" wrote:
> Hi all,
> SQL novice here.
> I had a SQL Server 2000 machine that died, but it had some
> data I need, so i pulled the drive, found the SQL data folder
> and copied it to a network location.
> On my SQL Server 2003 machine runnig SQL Server Express, I
> right click on Databases, select Attach, point to the database
> I want, and the process fials saying the data is read-only, make
> it read write and try again.
> Problem is, the files are not read-only. I checked and reset
> them several times, and each attempt fails with the same message.
> How can I attach this database to my sql server?
> Thanks,
> kpg
>|||> There is a article on Microsoft's web site that briefly discusses this
> issue on SQL 2005 Express:
> http://msdn2.microsoft.com/en-us/library/bb264564.aspx
> If you've already checked the permissions on the file, see if you can
> check the permissions you have on the database server and folder where
> the file is being written to. Your permissions may be different than
> what they were on the original DB server.
Thank you * 100!
I copied the db file into the data folder of the sql 2005 instance
and yes, I was able to attach it. So it was a folder permission
issue.
Thanks again!
kpg

Can't attach db - says read-only

Hi all,
SQL novice here.
I had a SQL Server 2000 machine that died, but it had some
data I need, so i pulled the drive, found the SQL data folder
and copied it to a network location.
On my SQL Server 2003 machine runnig SQL Server Express, I
right click on Databases, select Attach, point to the database
I want, and the process fials saying the data is read-only, make
it read write and try again.
Problem is, the files are not read-only. I checked and reset
them several times, and each attempt fails with the same message.
How can I attach this database to my sql server?
Thanks,
kpgThere is a article on Microsoft's web site that briefly discusses this issue
on SQL 2005 Express:
http://msdn2.microsoft.com/en-us/library/bb264564.aspx
If you've already checked the permissions on the file, see if you can check
the permissions you have on the database server and folder where the file is
being written to. Your permissions may be different than what they were on
the original DB server.
"kpg*" wrote:

> Hi all,
> SQL novice here.
> I had a SQL Server 2000 machine that died, but it had some
> data I need, so i pulled the drive, found the SQL data folder
> and copied it to a network location.
> On my SQL Server 2003 machine runnig SQL Server Express, I
> right click on Databases, select Attach, point to the database
> I want, and the process fials saying the data is read-only, make
> it read write and try again.
> Problem is, the files are not read-only. I checked and reset
> them several times, and each attempt fails with the same message.
> How can I attach this database to my sql server?
> Thanks,
> kpg
>|||> There is a article on Microsoft's web site that briefly discusses this
> issue on SQL 2005 Express:
> http://msdn2.microsoft.com/en-us/library/bb264564.aspx
> If you've already checked the permissions on the file, see if you can
> check the permissions you have on the database server and folder where
> the file is being written to. Your permissions may be different than
> what they were on the original DB server.
Thank you * 100!
I copied the db file into the data folder of the sql 2005 instance
and yes, I was able to attach it. So it was a folder permission
issue.
Thanks again!
kpg

Can't attach database

HI all, I'm trying to move a mdf from a dev machine onto a production server and when I try to re-attach I keep getting the following error " ...the mdf file is not a primary database file" ...and it won't attach.

It's SS2005, does anyone know why this error occurs.

Thanks

How did you detach the original database?|||

Thanks for the prompt Euan, I just found out the database wasn't detached properly, they just burned it onto a CD directly!..hopefully the correctly detached one will be OK.

Can't attach database

HI all, I'm trying to move a mdf from a dev machine onto a production server and when I try to re-attach I keep getting the following error " ...the mdf file is not a primary database file" ...and it won't attach.

It's SS2005, does anyone know why this error occurs.

Thanks

How did you detach the original database?|||

Thanks for the prompt Euan, I just found out the database wasn't detached properly, they just burned it onto a CD directly!..hopefully the correctly detached one will be OK.

Thursday, March 22, 2012

Cant Add new connection in SQL SERVER EXPRESS

Hi,

I am relatively new to this. I have installed VB 2005 and that has installed a version of SQL Server 2005 Express on my local development machine. I am using VB to develop some demo sites and i can create DB's in the App_Data file and they work when I test and run then by pressing Ctrl + F5.

However i have some demo tutorials that require Northwind and Pubs to do them. So i have installed Northwind and Pubs using the cms prompt and the InstNwnd.sql install. They said everything has been installed fine.

This is where the problem starts. I open new connection in VB, or asses for that matter and try to open my local server machine (just my desktop running WindowsXP pro), Which is called Optiplex. Sometimes i get the optiplex appear in the dropdown that asks for your to choose a server and other times it doesnt. Eevn if the machine appears it doesnt let me chose Pubs or northwind from the second drop down.

I think i must have SQexpress running on the machined named Optiplex because i have the SQL server configuartion manger on it. That tells me i am running SQL Server(SQLEXPRESS) and SQL Server Browser both switched on and running. By the way i have set my SQL manager to run as Local service.

One thing that i consider strange is that when i have had SQLServer Express running on other machines normally there was a little icon running in the right hand corner of the the task bar.

Does anyone know what is going on with my mchine and have i got the SQL server setup correctly?

Just one last piece of additionally information is that i have a folder called C:\SQL Server 2000 Sample Databases which is where the MDF files are located.

Thanks a million Sanson

Hi Sanson,

Could you give me some more details? Which database will the appliation connect to? SQL Server 2005 Express or SQL Server 2000 ? You mentioned that you have a folder called C:\SQL Server 200 Sample Database which is where the MDF files located, Have these MDF files (Northwind and Pubs) be attached to SQL Server by using Management Satudio? If not,pls follow the steps below:

1. Copy your .mdf file and .ldf(if exists) to another folder.
2. Right click on Databases, and select Attach from the popup menu.
3. In the Attach Databases dialog box,click Add button and select the .mdf file.
4. Click OK to finish, and the database will be atached to your database list in Management Studio.

Thanks.

|||

Thanks for your help.

What had happened was i hadnt installed SQL Management Studio. Once i did everything got sorted out and they were in there.

However i still cant use the upsizing wizard in Access to upsize a database to SQL. I always get a connect error.

Now however i get a the name of my server come up in the dropdown box, which is somethong i suppose.

sql

Cant add ASPNET login to SQL Server

Here's the situation:

SQL Server is on one machine.
ASP.net is running on a different machine named THALES, which has the ASPNET account on it.
Both machines are on the same domain.

I am trying to add the THALES\ASPNET as a SQL Server login so that I can connect using Windows Authentication. When I try to add THALES\ASPNET, I get this message:
Error 15401: Windows NT user or group 'THALES\ASPNET' not found. Check the name again.

Any suggestions?You need to create an ASPNET user on the SQL Server machine, and give it the same password as the ASPNET user on the Web Server. By default, the password for the ASPNET user is autogenerated. You will need to change this in the Machin.Config so that it is a known password that you can then use for the ASPNET user on the SQL Server machine.|||Thank you, Douglas, that helped.

Can't add a SQL Database (2005 Express Edition) to a C# Project over RDP

Good Afternoon.

I installed C# with SQL Server 2005 Express Edition. Everything works fine on the account I installed it on, on the local machine. However.

1) I can't connect using RDP to that same account and use SQL. It times out.
2) Other users on that computer cannot make user of SQL. Also times out.

I couldn't find documentation on these issues.

Thanks,

Philski

When you first set up the SQL Express edition the system installs with the networking systems turned off. You will need to activate the remote connections on the sql server express system by using the SQL Server Configuration Manager tools. (These should have also been installed when you installed the sql express system)

|||Didn't work.

Not sure why i should need to open TCP or memory pipes anyways, since RDP is just a reflection of the desktop, and local users do not need a network connection.

I get the same error message when I try to add a database to my C# project, "Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed"

Thanks,

Philski|||

Phil, here is a thread from the DB Engine forum that seems to address this issue. Were you logged into the box through TS or on the box locally?

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=116459&SiteID=1

Thanks,
Sam Lester (MSFT)

sql

Monday, March 19, 2012

Cannot view SQL Server logs

Just installed SQL2005 on a clustered Windows server. Trying to view
the SQL Server logs from my client machine, but receive the following:
TITLE: Microsoft SQL Server Management Studio
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
For help, click:
[url]http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476[ /url]
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or
batch. (Microsoft.SqlServer.ConnectionInfo)
A severe error occurred on the current command. The results, if any,
should be discarded. (Microsoft SQL Server, Error: 0)
For help, click:
[url]http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00 .1399&EvtSrc=MSSQLServer&EvtID=0&LinkId=20476[/url]
BUTTONS:
OK
Everything else in the Management Studio works fine. Can anyone
interpret this?
I can't interpret or solve, but I can confirm that it also happens on our
clusters.

> Everything else in the Management Studio works fine. Can anyone
> interpret this?
>

Cannot view SQL Server logs

Just installed SQL2005 on a clustered Windows server. Trying to view
the SQL Server logs from my client machine, but receive the following:
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)
--
A severe error occurred on the current command. The results, if any,
should be discarded. (Microsoft SQL Server, Error: 0)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=0&LinkId=20476
--
BUTTONS:
OK
--
Everything else in the Management Studio works fine. Can anyone
interpret this?I can't interpret or solve, but I can confirm that it also happens on our
clusters.
> Everything else in the Management Studio works fine. Can anyone
> interpret this?
>|||Interesting...I found out that when I was trying to view the logs, for
some reason it was trying to direct me to the virtual servername used
by the Data Group of the cluster. I don't know why it would do that.
I created an alias for the data group name, and pointed it to the ip
address of the sql server instance, and it connects properly now.
Not sure if I explained this right, I'm kinda new to clusters, but
hopefully this will help you.
Aaron Bertrand [SQL Server MVP] wrote:
> I can't interpret or solve, but I can confirm that it also happens on our
> clusters.
>
>
> > Everything else in the Management Studio works fine. Can anyone
> > interpret this?
> >

Cannot view SQL Server logs

Just installed SQL2005 on a clustered Windows server. Trying to view
the SQL Server logs from my client machine, but receive the following:
TITLE: Microsoft SQL Server Management Studio
--
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
For help, click:
http://go.microsoft.com/fwlink?Prod...er&LinkId=20476
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or
batch. (Microsoft.SqlServer.ConnectionInfo)
A severe error occurred on the current command. The results, if any,
should be discarded. (Microsoft SQL Server, Error: 0)
For help, click:
http://go.microsoft.com/fwlink?Prod...=0&LinkId=20476
BUTTONS:
OK
--
Everything else in the Management Studio works fine. Can anyone
interpret this?I can't interpret or solve, but I can confirm that it also happens on our
clusters.

> Everything else in the Management Studio works fine. Can anyone
> interpret this?
>|||Interesting...I found out that when I was trying to view the logs, for
some reason it was trying to direct me to the virtual servername used
by the Data Group of the cluster. I don't know why it would do that.
I created an alias for the data group name, and pointed it to the ip
address of the sql server instance, and it connects properly now.
Not sure if I explained this right, I'm kinda new to clusters, but
hopefully this will help you.
Aaron Bertrand [SQL Server MVP] wrote:[vbcol=seagreen]
> I can't interpret or solve, but I can confirm that it also happens on our
> clusters.
>
>

Cannot View Server Logs

I have SQL Server 2005 Express on a Windows XP SP2 machine. Everything works fine and I have several dbs running. How ever I was wanting to optimize some programs and needed to watch the server and see what it is processing. I log into SQL Management Studio Express and when I go to Management->Server Logs I see the logs and the Activity Monitor. If I right click on the log all I see is Refresh. If I doule click nothing happens. I can view the Activity Monitor and the processes going.

I am sure it is a permission thing or something along those lines. I can not for the life of me figure it and have spent a couple days on google and these forums. I have tried with the SA, my defined users, and the local windows administrator. Is log viewing not allowed in SQL Server Express?

Thanks!

Michael

hi Michael,

SSMSE does not provide that feature.. if you like to inspect the SQL Server log files, you can navigate to the \Program Files\Microsoft SQL Server\MSSQL.x\MSSQL\LOG folder and open the ERRORLOG file with Notepad, as it's just plain text..

regards

|||Thanks, good to know I am not crazy.

So does any of the Express additions support logging? I want to turn on query logging so I can see the queries coming in and nail down the one that is hosing the system.

Thanks!
Michael
|||

hi Michael,

wait a moment ...

SQLExpress logs it's "system" activities to the SQL Server Errolog file(s) as full blown editions do.. just the SSMSE tool does not provide a direct way to view the errorlog file(s)...

>I want to turn on query logging so I can see the queries coming in and nail down the one that is hosing the system.
this is another story... all SQL Server editions use the database's transaction log file(s).. but you can not directly inspect those files as no public API exists... there's a bunch to third party tools like Luminigent's Log Explorer that can perform that task, but you probably looking for another feature as well.. your last sentence implies the use of Profiler, but this tool is not available with the Express edition... you can use SQL Traces, the underlying architecture used by Profiler, but with no graphical tool to examine results/setting options..

regards

|||Wow I did not expect it to be so annoying to just watch incoming queries into the server.

There is nothing like mysqls logging where I can log incoming queries to a file?

$1000 to view some logs is alot...

Thanks!
Michael
|||

hi Michael,

not directly... but, again, you can start your own trace to capture server's activity..

regards

Wednesday, March 7, 2012

Cannot Subscribe Using Windows Synchronization Manager

Hi,
I'm using two instances of SQL Server 2005 Developer Edition (SP2) on the
same machine. One instance is Publisher and Distributor and the other is
Subscriber. When I try to use Windows Synchronization Manager to subscribe
to the publication, I get this error:
The SQL Server publication uses features that the current version of the
Subscriber does not support. The subscriber should be upgraded to 'Unknown
version of Microsoft SQL Server'.
Any help would be greatly appreciated,
Leila
Can you check the compatibility level of the subscription database?
Also see if you can do a simple pull subscription to see if that works.
Hilary Cotter
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
"Leila" <Leilas@.hotpop.com> wrote in message
news:%23ESWMUCTHHA.1200@.TK2MSFTNGP02.phx.gbl...
> Hi,
> I'm using two instances of SQL Server 2005 Developer Edition (SP2) on the
> same machine. One instance is Publisher and Distributor and the other is
> Subscriber. When I try to use Windows Synchronization Manager to subscribe
> to the publication, I get this error:
> The SQL Server publication uses features that the current version of the
> Subscriber does not support. The subscriber should be upgraded to 'Unknown
> version of Microsoft SQL Server'.
> Any help would be greatly appreciated,
> Leila
>
|||compatibility level is 9, pull subscription without Synchronization Manager
works!
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%234mNP4DTHHA.4404@.TK2MSFTNGP03.phx.gbl...
> Can you check the compatibility level of the subscription database?
> Also see if you can do a simple pull subscription to see if that works.
> --
> Hilary Cotter
> 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
>
> "Leila" <Leilas@.hotpop.com> wrote in message
> news:%23ESWMUCTHHA.1200@.TK2MSFTNGP02.phx.gbl...
>
|||Sounds like something is wrong with Windows Synchronization Manager. Can you
try from another machine?
Hilary Cotter
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
"Leila" <Leilas@.hotpop.com> wrote in message
news:OJC3wRFTHHA.4956@.TK2MSFTNGP04.phx.gbl...
> compatibility level is 9, pull subscription without Synchronization
> Manager works!
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:%234mNP4DTHHA.4404@.TK2MSFTNGP03.phx.gbl...
>
|||I'll try that!
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%23OP$xzFTHHA.5108@.TK2MSFTNGP06.phx.gbl...
> Sounds like something is wrong with Windows Synchronization Manager. Can
> you try from another machine?
> --
> Hilary Cotter
> 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
>
> "Leila" <Leilas@.hotpop.com> wrote in message
> news:OJC3wRFTHHA.4956@.TK2MSFTNGP04.phx.gbl...
>
|||I'll try that!
One more thing: BOL says that interactive conflict resolution is not
available when you synchronize via SSMS. Then why is there such an option
when you create the subscription in SSMS?
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%23OP$xzFTHHA.5108@.TK2MSFTNGP06.phx.gbl...
> Sounds like something is wrong with Windows Synchronization Manager. Can
> you try from another machine?
> --
> Hilary Cotter
> 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
>
> "Leila" <Leilas@.hotpop.com> wrote in message
> news:OJC3wRFTHHA.4956@.TK2MSFTNGP04.phx.gbl...
>
|||It is for subscriptions that you will pull through WSM. Note you have to
also enable interactive conflict resolution in WSM as well
Hilary Cotter
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
"Leila" <Leilas@.hotpop.com> wrote in message
news:%23w5nP4HTHHA.2124@.TK2MSFTNGP06.phx.gbl...
> I'll try that!
> One more thing: BOL says that interactive conflict resolution is not
> available when you synchronize via SSMS. Then why is there such an option
> when you create the subscription in SSMS?
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:%23OP$xzFTHHA.5108@.TK2MSFTNGP06.phx.gbl...
>
>

Cannot start up SQL 2000

I just installed the SQL Server 2000 with custom option:
Druing the setup, in the screen of Service Account, I use my Windows machine
login (this is the login I use when the pc is started up), ie 'Alan' instead
of LocalSystem.
After installation, I config the Microsoft Search service by using the same
account, ie 'Alan' rather than the LocalSystem. So both Microsoft Search
Service and MSSQL Server use the 'Alan' login, in Control Panel - Admin
Tools - Services show both 'Log On As' .\Alan.
However, when I tried to run the EM, click the server instance, there is an
error:
'A connection cannot be established to 'Alan2'.
Reason: login failed for user 'sa'.
Reason:Not associated with trusted SQL Server connection.
Please verify SQL Server is running and check your SQL Server registration
properties and try again.'
I checked both MSSQL Server, SQLServer Agent are started.
Can someone give me any idea please?In EM, right-click on the server and then Edit Registration Properties.
Have it use Windows authentication.
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
"Man Utd" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
news:eet8EBKhGHA.1612@.TK2MSFTNGP04.phx.gbl...
I just installed the SQL Server 2000 with custom option:
Druing the setup, in the screen of Service Account, I use my Windows machine
login (this is the login I use when the pc is started up), ie 'Alan' instead
of LocalSystem.
After installation, I config the Microsoft Search service by using the same
account, ie 'Alan' rather than the LocalSystem. So both Microsoft Search
Service and MSSQL Server use the 'Alan' login, in Control Panel - Admin
Tools - Services show both 'Log On As' .\Alan.
However, when I tried to run the EM, click the server instance, there is an
error:
'A connection cannot be established to 'Alan2'.
Reason: login failed for user 'sa'.
Reason:Not associated with trusted SQL Server connection.
Please verify SQL Server is running and check your SQL Server registration
properties and try again.'
I checked both MSSQL Server, SQLServer Agent are started.
Can someone give me any idea please?

Cannot start SQL Trace (Profiler) on Windows 2000 Professional

Hello all!
I have installed SQL Server 7 Client components on a Windows 2000
Professional machine.
I can start the Query analyzer and I can use it to connect to servers.
However, when I try to start SQL trace, I am getting the following
error message
"sqltrace.exe, not a valid win32 application."
Have any of you come across this problem? Please suggest a solution.
If you need any more information, please let me know.
Thank you,
Martin.
The file could have been corrupted. Have you checked your disk to see if
there are any errors?
You may be able to fix it by reinstalling the client utilities, if that is
not a problem.
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Martin Thomas" <martintms99@.yahoo.com> wrote in message
news:752207f2.0408090315.1eb0d689@.posting.google.c om...
> Hello all!
> I have installed SQL Server 7 Client components on a Windows 2000
> Professional machine.
> I can start the Query analyzer and I can use it to connect to servers.
> However, when I try to start SQL trace, I am getting the following
> error message
> "sqltrace.exe, not a valid win32 application."
> Have any of you come across this problem? Please suggest a solution.
> If you need any more information, please let me know.
> Thank you,
> Martin.

Cannot start Sql service

Hi guys,
I had 2 SQL Servers on my machine, one was the MSDE netSDK
and the other was MS SQL Server 2000.
I removed the latter as I was quite happy with MSDE but
as soon as I removed it the play icon in the SQL Manager
disappeared and I get a message saying
'Cannot find the file specified' as there is nothing in
the services drop down combo. How do I fix this. I still
have all my databases in the netSDK.
Thanks in advance
Regards
tribalIfI remember correctly removing the SQL Server instance removes all of the
GUI tools. You'll need to find a free GUI for the MSDE since the once that
came with SQL Server are gone.
"tribal" <tribal@.mail.com> wrote in message
news:04a601c368ab$0d62f030$a001280a@.phx.gbl...
> Hi guys,
> I had 2 SQL Servers on my machine, one was the MSDE netSDK
> and the other was MS SQL Server 2000.
> I removed the latter as I was quite happy with MSDE but
> as soon as I removed it the play icon in the SQL Manager
> disappeared and I get a message saying
> 'Cannot find the file specified' as there is nothing in
> the services drop down combo. How do I fix this. I still
> have all my databases in the netSDK.
> Thanks in advance
> Regards
> tribal