Showing posts with label local. Show all posts
Showing posts with label local. Show all posts

Thursday, March 29, 2012

Can't connect after changing IP address

After changing from DHCP network address to a static IP address I can
not connect to my local database using ".\MyDBS" notation, howver
"127.0.0.1\MyDBS" works. Also, both work after restarting the SQL
service.
I am using the query analyzer to test success or failure.
My event logs show nothing and my SQL logs show no errors.
Any ideas on how to debug this further or solve it altogether?
Thank youHi Arron,
Thank you for using the newsgroup and it is my pleasure to help you with
you issue.
From your information, after change the IP, in the Query Analyzer, you
could not connect to my local database using ".\MyDBS" while
"127.0.0.1\MyDBS" works. After you restart the SQL Server service, this
problem do not happen, right?
I want to go forward with some more information since I could not
re-produce this problem on my computer. Do you encouter any error message
when using ".\MYDBS" that indicating you cannot connect to the server? How
about using the '(local)'? If you do not restart the SQL Server service,
it will not connect to the server even after some time? If you connect from
another machine by Query Analyer, do you meet the same problem?
When a SQL Server is started, it will listen to the IP and the port of when
it is started. So, when you change the IP address, you should restart the
SQL Server service and then it will listen to the new IP address. For the
localhost and the 127.0.0.1 will be the local machine.
You could refer to the following article for the name resolution:
http://www.microsoft.com/technet/pr.../ewsa/ewsach08.
mspx#XSLTsection124121120120
Hope this helps. If you still have questions, please feel free to post
message here and I am glad to help.
Thanks.
Sincerely Yours
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.|||Hi Aaron,
I am reviewing you post and since we have not heard from you for some time
in the newsgroup, I wonder if you got answer from my answer. For any
question, please post your message here and we are glad to help.
Thanks.
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.

Can't connect after change the security setting

Hi, Experts! I very new to SQL server. I made a stupid movement by mistakenl
y
change the security of property of local(windows NT) from log in using this
account to system account. After the machine restarted, i can't no longer
start up SQL server. When I click local (window NT) in enterprise manager it
says "a connection could not be established to local. Reason, SQL serer
doesn't exist or access denied". I think it is the change of security that
the access was denied. How should I resolve this problem' Thanks so much.Thats weird, did the SQLServer service start up ? Look in the Service
manager. The service account can be switched in here. if you changed
the authentication method you can set it back via the registry entry as
mentioned in here:
---
http://support.microsoft.com/defaul...b;EN-US;q285097
---
INF: How to Change the Default Login Authentication Mode to SQL While
Installing SQL Server 2000 Desktop Engine by Using Windows Installer
---
<snip>
Another way to change the security mode after installation is to stop
SQL Server and set the appropriate registry key for your installation:
Default instance:
HKLM\Software\Microsoft\MSSqlserver\MSSq
lServer\LoginMode
Named instance:
HKLM\Software\Microsoft\Microsoft SQL Server\Instance
Name\MSSQLServer\LoginMode
to 2 for mixed-mode or 1 for integrated. (Integrated is the default
setup for the SQL Server 2000 Data Engine.)
</snip>
-URL---
HTH, Jens Suessmeyer.|||Jens,
Thank you so very much for your reply. I changed the registry loginmode from
2 to 1 and it did not work; I tried to change from 1 to 0, it did not work
either. In the service, I was not able to start up MSSQLSERVER. I got this
message "MSSQL SERVER service on local computer started and then stopped.
Some services stop automatically if they have no work to do ...".
Thanks.
"Jens" wrote:

> Thats weird, did the SQLServer service start up ? Look in the Service
> manager. The service account can be switched in here. if you changed
> the authentication method you can set it back via the registry entry as
> mentioned in here:
> ---
> http://support.microsoft.com/defaul...b;EN-US;q285097
> ---
> INF: How to Change the Default Login Authentication Mode to SQL While
> Installing SQL Server 2000 Desktop Engine by Using Windows Installer
> ---
> <snip>
> Another way to change the security mode after installation is to stop
> SQL Server and set the appropriate registry key for your installation:
>
> Default instance:
> HKLM\Software\Microsoft\MSSqlserver\MSSq
lServer\LoginMode
>
> Named instance:
> HKLM\Software\Microsoft\Microsoft SQL Server\Instance
> Name\MSSQLServer\LoginMode
>
> to 2 for mixed-mode or 1 for integrated. (Integrated is the default
> setup for the SQL Server 2000 Data Engine.)
> </snip>
>
> -URL---
>
> HTH, Jens Suessmeyer.
>|||Lokk in the event log to see why it failed, did you try to change the
service accoutn back to the original one in the service manager ?
Some error occured and you have to know which one, this information is
presented in the event log.
Jens Suessmeyer.|||Thank you Jens. You saved me. I was panic about it. It is the evaluation
period expired. We have license now. How can I update the license without
losing the data? If not doable it is ok too. Thanks. whew...
"Jens" wrote:

> Lokk in the event log to see why it failed, did you try to change the
> service accoutn back to the original one in the service manager ?
> Some error occured and you have to know which one, this information is
> presented in the event log.
> Jens Suessmeyer.
>|||http://support.microsoft.com/defaul...kb;en-us;281574
HTH, Jens Suessmeyer.|||Thank you so very much Jens. You are very helpful!!
"jsuessmeyer@.web.de" wrote:

> http://support.microsoft.com/defaul...kb;en-us;281574
> HTH, Jens Suessmeyer.
>

Can't connect after change the security setting

Hi, Experts! I very new to SQL server. I made a stupid movement by mistakenly
change the security of property of local(windows NT) from log in using this
account to system account. After the machine restarted, i can't no longer
start up SQL server. When I click local (window NT) in enterprise manager it
says "a connection could not be established to local. Reason, SQL serer
doesn't exist or access denied". I think it is the change of security that
the access was denied. How should I resolve this problem? Thanks so much.
Thats weird, did the SQLServer service start up ? Look in the Service
manager. The service account can be switched in here. if you changed
the authentication method you can set it back via the registry entry as
mentioned in here:
http://support.microsoft.com/default...;EN-US;q285097
INF: How to Change the Default Login Authentication Mode to SQL While
Installing SQL Server 2000 Desktop Engine by Using Windows Installer
<snip>
Another way to change the security mode after installation is to stop
SQL Server and set the appropriate registry key for your installation:
Default instance:
HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\Lo ginMode
Named instance:
HKLM\Software\Microsoft\Microsoft SQL Server\Instance
Name\MSSQLServer\LoginMode
to 2 for mixed-mode or 1 for integrated. (Integrated is the default
setup for the SQL Server 2000 Data Engine.)
</snip>
-URL---
HTH, Jens Suessmeyer.
|||Jens,
Thank you so very much for your reply. I changed the registry loginmode from
2 to 1 and it did not work; I tried to change from 1 to 0, it did not work
either. In the service, I was not able to start up MSSQLSERVER. I got this
message "MSSQL SERVER service on local computer started and then stopped.
Some services stop automatically if they have no work to do ...".
Thanks.
"Jens" wrote:

> Thats weird, did the SQLServer service start up ? Look in the Service
> manager. The service account can be switched in here. if you changed
> the authentication method you can set it back via the registry entry as
> mentioned in here:
> http://support.microsoft.com/default...;EN-US;q285097
> INF: How to Change the Default Login Authentication Mode to SQL While
> Installing SQL Server 2000 Desktop Engine by Using Windows Installer
> <snip>
> Another way to change the security mode after installation is to stop
> SQL Server and set the appropriate registry key for your installation:
>
> Default instance:
> HKLM\Software\Microsoft\MSSqlserver\MSSqlServer\Lo ginMode
>
> Named instance:
> HKLM\Software\Microsoft\Microsoft SQL Server\Instance
> Name\MSSQLServer\LoginMode
>
> to 2 for mixed-mode or 1 for integrated. (Integrated is the default
> setup for the SQL Server 2000 Data Engine.)
> </snip>
>
> -URL---
>
> HTH, Jens Suessmeyer.
>
|||Lokk in the event log to see why it failed, did you try to change the
service accoutn back to the original one in the service manager ?
Some error occured and you have to know which one, this information is
presented in the event log.
Jens Suessmeyer.
|||Thank you Jens. You saved me. I was panic about it. It is the evaluation
period expired. We have license now. How can I update the license without
losing the data? If not doable it is ok too. Thanks. whew...
"Jens" wrote:

> Lokk in the event log to see why it failed, did you try to change the
> service accoutn back to the original one in the service manager ?
> Some error occured and you have to know which one, this information is
> presented in the event log.
> Jens Suessmeyer.
>
|||http://support.microsoft.com/default...b;en-us;281574
HTH, Jens Suessmeyer.
|||Thank you so very much Jens. You are very helpful!!
"jsuessmeyer@.web.de" wrote:

> http://support.microsoft.com/default...b;en-us;281574
> HTH, Jens Suessmeyer.
>
sql

can't connect 2005 reporting server...need help

We installed sql 2005 server and reporting services (standard edition) on
window2003 with sp1 and IIS 6.0 is running on it as well. I am in local
admin and got error when i try to connect report server:
Cannot execute a program. The command being executed was
"C:\WINNT\Microsoft.NET\Framework\v2.0.50727\csc.exe" /noconfig /fullpaths
@."C:\WINNT\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
Files\reports$sql2005\47980326\bf0ad169\lzwjfwcj.cmdline".
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.
Exception Details: System.Runtime.InteropServices.ExternalException: Cannot
execute a program. The command being executed was
"C:\WINNT\Microsoft.NET\Framework\v2.0.50727\csc.exe" /noconfig /fullpaths
@."C:\WINNT\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
Files\reports$sql2005\47980326\bf0ad169\lzwjfwcj.cmdline".
Source Error:
An unhandled exception was generated during the execution of the current web
request. Information regarding the origin and location of the exception can
be identified using the exception stack trace below.
anyone knows about this and thanks alot for a help
Karen,On Apr 27, 1:50 pm, Karen Chen <KarenC...@.discussions.microsoft.com>
wrote:
> We installed sql 2005 server and reporting services (standard edition) on
> window2003 with sp1 and IIS 6.0 is running on it as well. I am in local
> admin and got error when i try to connect report server:
> Cannot execute a program. The command being executed was
> "C:\WINNT\Microsoft.NET\Framework\v2.0.50727\csc.exe" /noconfig /fullpaths
> @."C:\WINNT\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
> Files\reports$sql2005\47980326\bf0ad169\lzwjfwcj.cmdline".
> Description: An unhandled exception occurred during the execution of the
> current web request. Please review the stack trace for more information about
> the error and where it originated in the code.
> Exception Details: System.Runtime.InteropServices.ExternalException: Cannot
> execute a program. The command being executed was
> "C:\WINNT\Microsoft.NET\Framework\v2.0.50727\csc.exe" /noconfig /fullpaths
> @."C:\WINNT\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
> Files\reports$sql2005\47980326\bf0ad169\lzwjfwcj.cmdline".
> Source Error:
> An unhandled exception was generated during the execution of the current web
> request. Information regarding the origin and location of the exception can
> be identified using the exception stack trace below.
> anyone knows about this and thanks alot for a help
> Karen,
I received your email and noticed that you posted here as well. If you
do not have the .NET 2.0 framework installed, this might be the
problem.
Regards,
Enrique Martinez
Sr. Software Consultant

Can't connect 2005 reporting server

We installed sql 2005 server and reporting services (standard edition) on
window2003 with sp1 and IIS 6.0 is running on it as well. I am in local
admin and got error when i try to connect report server:
Cannot execute a program. The command being executed was
"C:\WINNT\Microsoft.NET\Framework\v2.0.50727\csc.exe" /noconfig /fullpaths
@."C:\WINNT\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
Files\reports$sql2005\47980326\bf0ad169\lzwjfwcj.cmdline".
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.
Exception Details: System.Runtime.InteropServices.ExternalException: Cannot
execute a program. The command being executed was
"C:\WINNT\Microsoft.NET\Framework\v2.0.50727\csc.exe" /noconfig /fullpaths
@."C:\WINNT\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
Files\reports$sql2005\47980326\bf0ad169\lzwjfwcj.cmdline".
Source Error:
An unhandled exception was generated during the execution of the current web
request. Information regarding the origin and location of the exception can
be identified using the exception stack trace below.
anyone knows about this and thanks alot for a help
Karen,On Apr 27, 2:24 pm, Karen Chen <KarenC...@.discussions.microsoft.com>
wrote:
> We installed sql 2005 server and reporting services (standard edition) on
> window2003 with sp1 and IIS 6.0 is running on it as well. I am in local
> admin and got error when i try to connect report server:
> Cannot execute a program. The command being executed was
> "C:\WINNT\Microsoft.NET\Framework\v2.0.50727\csc.exe" /noconfig /fullpaths
> @."C:\WINNT\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
> Files\reports$sql2005\47980326\bf0ad169\lzwjfwcj.cmdline".
> Description: An unhandled exception occurred during the execution of the
> current web request. Please review the stack trace for more information about
> the error and where it originated in the code.
> Exception Details: System.Runtime.InteropServices.ExternalException: Cannot
> execute a program. The command being executed was
> "C:\WINNT\Microsoft.NET\Framework\v2.0.50727\csc.exe" /noconfig /fullpaths
> @."C:\WINNT\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
> Files\reports$sql2005\47980326\bf0ad169\lzwjfwcj.cmdline".
> Source Error:
> An unhandled exception was generated during the execution of the current web
> request. Information regarding the origin and location of the exception can
> be identified using the exception stack trace below.
> anyone knows about this and thanks alot for a help
> Karen,
Please refer to my previous post at:
http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/9efeaacdc0875e6d/7ce06f2ec8a78f36#7ce06f2ec8a78f36
Regards,
Enrique Martinez
Sr. Software Consultant|||Hi Enrique,
Thanks your replay and i do have .NET 2.0 installed. I feel like its
security issue.
What is security context of .NETservice account (NT
Authority\NetworkService)? and how do you confiure this account for web
service identity?
"EMartinez" wrote:
> On Apr 27, 2:24 pm, Karen Chen <KarenC...@.discussions.microsoft.com>
> wrote:
> > We installed sql 2005 server and reporting services (standard edition) on
> > window2003 with sp1 and IIS 6.0 is running on it as well. I am in local
> > admin and got error when i try to connect report server:
> > Cannot execute a program. The command being executed was
> > "C:\WINNT\Microsoft.NET\Framework\v2.0.50727\csc.exe" /noconfig /fullpaths
> > @."C:\WINNT\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
> > Files\reports$sql2005\47980326\bf0ad169\lzwjfwcj.cmdline".
> > Description: An unhandled exception occurred during the execution of the
> > current web request. Please review the stack trace for more information about
> > the error and where it originated in the code.
> >
> > Exception Details: System.Runtime.InteropServices.ExternalException: Cannot
> > execute a program. The command being executed was
> > "C:\WINNT\Microsoft.NET\Framework\v2.0.50727\csc.exe" /noconfig /fullpaths
> > @."C:\WINNT\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
> > Files\reports$sql2005\47980326\bf0ad169\lzwjfwcj.cmdline".
> >
> > Source Error:
> > An unhandled exception was generated during the execution of the current web
> > request. Information regarding the origin and location of the exception can
> > be identified using the exception stack trace below.
> >
> > anyone knows about this and thanks alot for a help
> >
> > Karen,
>
> Please refer to my previous post at:
> http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/9efeaacdc0875e6d/7ce06f2ec8a78f36#7ce06f2ec8a78f36
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||Hi Enrique,
Thanks your replay and we do have .Net 2.0 installed. I feel like that this
problem related to security issue.
How do you configure your web service account (NT Authoriry/NetworkServices)
?
Karen,
"EMartinez" wrote:
> On Apr 27, 2:24 pm, Karen Chen <KarenC...@.discussions.microsoft.com>
> wrote:
> > We installed sql 2005 server and reporting services (standard edition) on
> > window2003 with sp1 and IIS 6.0 is running on it as well. I am in local
> > admin and got error when i try to connect report server:
> > Cannot execute a program. The command being executed was
> > "C:\WINNT\Microsoft.NET\Framework\v2.0.50727\csc.exe" /noconfig /fullpaths
> > @."C:\WINNT\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
> > Files\reports$sql2005\47980326\bf0ad169\lzwjfwcj.cmdline".
> > Description: An unhandled exception occurred during the execution of the
> > current web request. Please review the stack trace for more information about
> > the error and where it originated in the code.
> >
> > Exception Details: System.Runtime.InteropServices.ExternalException: Cannot
> > execute a program. The command being executed was
> > "C:\WINNT\Microsoft.NET\Framework\v2.0.50727\csc.exe" /noconfig /fullpaths
> > @."C:\WINNT\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
> > Files\reports$sql2005\47980326\bf0ad169\lzwjfwcj.cmdline".
> >
> > Source Error:
> > An unhandled exception was generated during the execution of the current web
> > request. Information regarding the origin and location of the exception can
> > be identified using the exception stack trace below.
> >
> > anyone knows about this and thanks alot for a help
> >
> > Karen,
>
> Please refer to my previous post at:
> http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/9efeaacdc0875e6d/7ce06f2ec8a78f36#7ce06f2ec8a78f36
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>

Sunday, March 25, 2012

Can't Attach sqlexpress db

Hi,

After having published the timetracker starterkit from visual studio 2005 to local wwwroot,

I try to access my homepage with ie.

But still get the same error message :

An attempt to attach an auto-named database for file C:\Documents and Settings\Emmanuel\My Documents\Visual Studio 2005\WebSites\GestWares\App_Data\TimeTracker.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

This is how i configure my web.config :

<connectionStrings>

<remove name="LocalSqlServer"/>

<add name="LocalSqlServer" connectionString="Data Source=.\SQLExpress;Integrated Security=True;AttachDBFilename=|DataDirectory|\TimeTracker.mdf;User Instance=true"/>

<add name="aspnet_staterKits_TimeTracker" connectionString="Data Source=.\SQLExpress;Integrated Security=True;AttachDBFilename=|DataDirectory|\TimeTracker.mdf;User Instance=true"/>

<add name="ConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\TimeTracker.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>

</connectionStrings>

Has someone any idea how my connectionstrings statement has to look like?

thanks in advance.

Manu.

Hi,

Refer below links for work around.

http://www.aspspider.com/resources/Resource170.aspx

http://www.sqljunkies.com/WebLog/ktegels/archive/2005/11/15/17401.aspx

http://www.ozzu.com/ftopic43909.html

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

Hemantgiri S. Goswami

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

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

Tuesday, March 20, 2012

Can't access properties on Stored Procedures

Hi. I have set up an instance of SQL 2005 on my local computer. I use MS SQL Server Management Studio to login into my 2005 instance via Windows login. When I expand "Stored Procedures" under "Programmability" of the Database I want and go to a stored procedure and right click, I don't see the "properities" selection.

I know it's there because I can get to it on other instances but I can't get to it on my local instance. I added my windows user to my Logins and then to my database users but it didn't help.

Can anyone please tell me what I need to do so I can access the properties of the stored procedures?

Thanks

Your procedure was created with encryption option. Because this you can′t see the contents.

|||Its either an encryption problem (like already mentioned by the other poster) or you don′t have the appropiate permissions viewing the properties. Which access level does the account you are using have ? Is there a pas lock on the stored procedure symbol ?

Jens K. Suessmeyer.

http://www.sqlserver2005.de

Monday, March 19, 2012

Cant access (local) server

I folks. I have something going on with my local SQL instance. It's SQL 2000 Standard with SP3a on a W2k3 Server with SP1. It's been running fine for several months. I got brave over the weekend and broke something.

I installed the .Net Enterprise Architect and SQL Reporting Services. My SQL instance is still running, but I can't get to it through EM and SQLServerAgent won't start. When I try to start SQLServerAgent manually, it gets about halfway through the process, then shuts itself down again. I also have an MSDE instance that is not complaining at all.

I can get to the server from my applications. I can also register it in EM with the IP and get to it that way.

Here's what's in sqlagent.out:

2007-01-02 16:34:41 - ! [298] SQLServer Error: 6, Specified SQL server not found. [SQLSTATE 08001]
2007-01-02 16:34:41 - ! [298] SQLServer Error: 11004, ConnectionOpen (Connect()). [SQLSTATE 01000]
2007-01-02 16:34:41 - ! [000] Unable to connect to server '(local)'; SQLServerAgent cannot start
2007-01-02 16:34:42 - ? [098] SQLServerAgent terminated (normally)

I did confirm in the registry that the port is set to 1433. It's not blank or incorrect. I am also working with a local account that is in the administrators group. There is no AD structure at work.

Many thanks for any ideas. This one feels like a little needle in a big haystack.

EaglesYouc an't have a 2k and an msde instance both named local... one of them HAS to be a named instance. Which one is named?|||The MSDE instance is named. The SQL Server 2000 instance is local.|||what server name do you use to connect to msde?|||One question (which will lead to others..) Were the two instances (Both MSDE and SQL Server existing before all the other installs? And happily co-existing?|||Yes, the 2 instances have been happily co-existing for over a year and things have been very stable. Since it's all the SQL instances are test environment, there's quite of bit of database creation and deletion in both the SS2K and MSDE instance. I also freqently register my clients SQL servers when I'm on-site also. There is actually a third instance which is another MSDE instance. Here's a snippet of them:

(local) - SS2k WITH sp3a. Currently houses a database for Project server and several small company databases for an accounting app. This instance starts automatically. It has been in place for ever a year.

acsob- MSDE instance with several company databases for an accounting application. This instance and it's accompanying sqlserver agent start automatically. It has been in place for over year.

quickalerts - MSDE instance with an interface application to the SS2K accounting application. This instance and accompanying sqlserveragent are set to start manually and are rarely running. This instance was installed 2 weeks ago. It was running constantly during initial configuration and testing.

All these servers are test environments with very low usage. I use them to do software demos, training, and testing. There's rarely more than one user logged in to any of the servers.

Last night after I opened this thread I registered the local sql server instance using the machine IP (assigned by the DHCP server). I was able to get it using the IP address but not as (local). That brought to light another piece of possible useful info. About a month ago, I enabled the mail role on this machine so I could send mail when I'm on the road. That all worked fine with one exception. I can not send email to my own domain account. I can send email to any other domains. I can also receive email to myself that I send from my providers webmail. Not sure if this is relevant, but it's starting to feel like a dns issue somewhere.

Thanks.

Eagles|||I can now get to the the sql instance through EM. The hosts file contained the following entry:

127.0.0.1 localhost

I added this entry:

127.0.0.1 local

A network admin at a client site suggested this.

The sqlserveragent still starts and immediately shuts down.

Sunday, March 11, 2012

Cannot use Windows Authentication to connect to local Sql 2005

Hi,
I am building my workstation again, freshly installing everything.
The OS is Vista Business, 32 bit. I've installed Sql Server 2005
Developer Edition fine and applied service pack 2 successfully. It
seems to run fine, with one exception.
I can't logon using Windows Authentication. I'm a member of the Local
administrators group (as well as a Domain admin), but my domain
\username gets a logon denied error. I can logon just fine with the
sa account, but I prefer Windows Authentication.
Any ideas?
Thanks
AndyAndy (andyj@.med-associates.com) writes:
> I am building my workstation again, freshly installing everything.
> The OS is Vista Business, 32 bit. I've installed Sql Server 2005
> Developer Edition fine and applied service pack 2 successfully. It
> seems to run fine, with one exception.
> I can't logon using Windows Authentication. I'm a member of the Local
> administrators group (as well as a Domain admin), but my domain
> \username gets a logon denied error. I can logon just fine with the
> sa account, but I prefer Windows Authentication.
Did you run the special Vista thing at the end of the SP2 setup? Keep in
mind that on Vista you are normally not admin, only if you request and
confirm. Either start Mgmt Studio with Run As Administrator, or - better -
add your Windows user as a long and grant it CONTROL SERVER.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||On Jul 12, 6:30 pm, Erland Sommarskog <esq...@.sommarskog.se> wrote:
> Did you run the special Vista thing at the end of the SP2 setup? Keep in
> mind that on Vista you are normally not admin, only if you request and
> confirm. Either start Mgmt Studio with Run As Administrator, or - better -
> add your Windows user as a long and grant it CONTROL SERVER.
Yes, I ran the provisioning tool. I added my user specifically and
granted connect and control server, that seems to have worked. I
thought I had tried something similar by adding domain admins, but
that didn't seem to work.
Thanks for the tip.
Andy

Thursday, March 8, 2012

Cannot use anonymous methods inside SQLCLR...

Hi all,

The problem is: when you're trying to call in method MyMethod anonymous method that doesn't use local variables, deployment of the assembly will fail referring that MyMethod tries to store smth. in the static variable. Indeed, looking at the compiled CLR code, you can see that anonymous delegate is cached in the private static delegate and the call looks like:

If(ClassName.privateStaticDelegate == null)
ClassName.privateStaticDelegate = new MyDelegate(HiddenMethodName);
CallAnonymousMethod(ClassName.privateStaticDelegate);

Is there any workaround to fix this problem.

P.S. I googled about this problem and found only one article on it:
http://www.ayende.com/Blog/default,date,2005-12-26.aspx

Hi Almaz,

I'm not quite sure I understand the question, but we're pretty picky about statics in SAFE and EXTERNAL ACCESS assemblies. They should be okay if they're readonly or const, but otherwise not.

Cheers,

-Isaac

|||

Hi Isaac,

Here is the repro: Create a new SQL Server Project, add a following stored procedure and try to deploy the assembly:

using System;
using Microsoft.SqlServer.Server;
public partial class StoredProcedures
{
[SqlProcedure]
public static void StoredProcedure1()
{
int[] myIntArray = {0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11};
int i = Array.FindIndex(myIntArray, delegate (int value)
{
return value == 5;
});
}
}

Following variant works:

using System;
using Microsoft.SqlServer.Server;
public partial class StoredProcedures
{
[SqlProcedure]
public static void StoredProcedure1()
{
int[] myIntArray = {0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11};
int valueToFind = 5;
int i = Array.FindIndex(myIntArray, delegate (int value)
{
return value == valueToFind;
});
}
}

Thanks in advance,
Sergei Almazov

|||

Right, the problem is that we don't allow store into a static field. In this case, the store was an optimization by the C# compiler. We have a requirement that whenever compiler does this, it should mark the static field with [System.Runtime.CompilerServices.CompilerGenerated] attribute. Apparently, this didn't happen here.

There are two possible workarounds here:

1) mark the class with [System.Runtime.CompilerServices.CompilerGenerated] attribute

2) register the assembly as UNSAFE assembly.

We will follow up with C# compiler and fix the issue, so you can remove your workaround in the future.

-Xiaowei

Cannot use anonymous methods inside SQLCLR...

Hi all,

The problem is: when you're trying to call in method MyMethod anonymous method that doesn't use local variables, deployment of the assembly will fail referring that MyMethod tries to store smth. in the static variable. Indeed, looking at the compiled CLR code, you can see that anonymous delegate is cached in the private static delegate and the call looks like:

If(ClassName.privateStaticDelegate ==null)
ClassName.privateStaticDelegate =new MyDelegate(HiddenMethodName);
CallAnonymousMethod(ClassName.privateStaticDelegate);

Is there any workaround to fix this problem.

P.S. I googled about this problem and found only one article on it:
http://www.ayende.com/Blog/default,date,2005-12-26.aspx

Hi Almaz,

I'm not quite sure I understand the question, but we're pretty picky about statics in SAFE and EXTERNAL ACCESS assemblies. They should be okay if they're readonly or const, but otherwise not.

Cheers,

-Isaac

|||

Hi Isaac,

Here is the repro: Create a new SQL Server Project, add a following stored procedure and try to deploy the assembly:

using System;
using Microsoft.SqlServer.Server;
public partial class StoredProcedures
{
[SqlProcedure]
public static void StoredProcedure1()
{
int[] myIntArray = {0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11};
int i = Array.FindIndex(myIntArray, delegate (int value)
{
return value == 5;
});
}
}

Following variant works:

using System;
using Microsoft.SqlServer.Server;
public partial class StoredProcedures
{
[SqlProcedure]
public static void StoredProcedure1()
{
int[] myIntArray = {0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11};
int valueToFind = 5;
int i = Array.FindIndex(myIntArray, delegate (int value)
{
return value == valueToFind;
});
}
}

Thanks in advance,
Sergei Almazov

|||

Right, the problem is that we don't allow store into a static field. In this case, the store was an optimization by the C# compiler. We have a requirement that whenever compiler does this, it should mark the static field with [System.Runtime.CompilerServices.CompilerGenerated] attribute. Apparently, this didn't happen here.

There are two possible workarounds here:

1) mark the class with [System.Runtime.CompilerServices.CompilerGenerated] attribute

2) register the assembly as UNSAFE assembly.

We will follow up with C# compiler and fix the issue, so you can remove your workaround in the future.

-Xiaowei

Wednesday, March 7, 2012

Cannot transfer/copy database in one step like I could with 2000.

Hi,

I would like to know if there will every be a clean way to transfer a database from a remote server to a local server (and back again). I've tried several different approaches, but they all currently have bugs/problems.

I've looked into database publishing wizard - but this creates a huge script that takes 10x longer to run than the old DTS transfer.

I've tried copying data, and objects separate, but this requires multiple steps, using DTS this was all done in one step.

I've tried using SSIS Transfer SQL Objects, but the defaults are not created, using DTS, the ENTIRE database was transfered, which is what I want.

I've tried using SSIS Transfer Database, but even when I select "Online" mode, I get an error asking me to select at least one source file, but there is nothing to select (no files appear in the pop up window).

I've tried copy database or backup database, but I do not have suffient permission on the remote server for these.

So many different ways to do it, but all fail!

PLEASE - make a simple way to transfer a database from a remote host and back again. I want to be able to select a database source and destination and have the database copied. PLEASE - at least restore the old way until other options are working first.

mpavlik wrote:

I've tried using SSIS Transfer Database, but even when I select

"Online" mode, I get an error asking me to select at least one source

file, but there is nothing to select (no files appear in the pop up

window).

Offline:
Once you set SourceConnection and SourceDatabaseName, you should be able to set the network share for database files to be transferred by clicking on "..." in SourceDatabaseFiles value column.

Online:
Once you set SourceConnection and SourceDatabaseName, the value of source database files is automatically populated.

Do you see this behavior? If not, please report what you are observing and we might be able to help.|||

Offline - I am not able to set the network share because I cannot browse (the window pops up, but there are no files to select). This may be a permission issue with the host server. I don't even know what the path would be to type it in.

Online - yes, the database name is auto-populated (or I can type it in), however when I try to run the package, validation fails because "at least one source must be selected"... Maybe I do not understand the error message, but I am assuming this is because the path to the database file is not selected ? ... even though it is greyed out. I don't know what else it could be, because everything else is populated.

Try looking at these:

http://manycounselors.com/taskdetail.jpg

http://manycounselors.com/taskerror.jpg

|||In the image taskdetail.jpg, SourceDatabaseFiles value is not set. This property is set automatically after you select the database name. If you type an invalid database name, then the source database files property is not automatically populated. I think you typed the source database name instead of selecting it from the drop-down box. You might have entered an invalid database name and your error message could be due this reason. Try selecting the source database instead of typing. (You can see the list of available databases in the server by clicking on the button that appears in the right end of the property value column. This button appears when you click on the value column.)|||

I double checked it... I am selecting the database from the drop down list. The problem is that the database source file is not being automatically selected. It stays blank. Is this only happening for me? Seems like a bug.

|||Can anyone confirm this as a bug, or tell me what I am doing wrong?|||I continue to experience this error. Can someone please help... This is a bug?!?|||I could not get to repro this in my machines? Could there be something wrong with your install? Is there another machine that you can use to repeat this behavior?|||I get exactly the same error, on a brand new install of SQL 2005 SP2 / Visual Studio 2005 SP1. I'm definitely selecting my source database from the dropdown (not typing it in) and the SourceDatabaseFiles file field is not autopopulated, whether the method is DatabaseOnline or DatabaseOffline. This seems doubly poor as I don't even *need* the source file specified to run a DatabaseOnline transfer, but nevertheless because the system fails to populate it, I can't run the package! It fails with the error message "At least one source file must be specified."

Like mpavlik above I'm left with no easy bug free way of transferring my database between servers which kind of sucks ...

Cannot transfer/copy database in one step like I could with 2000.

Hi,

I would like to know if there will every be a clean way to transfer a database from a remote server to a local server (and back again). I've tried several different approaches, but they all currently have bugs/problems.

I've looked into database publishing wizard - but this creates a huge script that takes 10x longer to run than the old DTS transfer.

I've tried copying data, and objects separate, but this requires multiple steps, using DTS this was all done in one step.

I've tried using SSIS Transfer SQL Objects, but the defaults are not created, using DTS, the ENTIRE database was transfered, which is what I want.

I've tried using SSIS Transfer Database, but even when I select "Online" mode, I get an error asking me to select at least one source file, but there is nothing to select (no files appear in the pop up window).

I've tried copy database or backup database, but I do not have suffient permission on the remote server for these.

So many different ways to do it, but all fail!

PLEASE - make a simple way to transfer a database from a remote host and back again. I want to be able to select a database source and destination and have the database copied. PLEASE - at least restore the old way until other options are working first.

mpavlik wrote:

I've tried using SSIS Transfer Database, but even when I select "Online" mode, I get an error asking me to select at least one source file, but there is nothing to select (no files appear in the pop up window).

Offline:
Once you set SourceConnection and SourceDatabaseName, you should be able to set the network share for database files to be transferred by clicking on "..." in SourceDatabaseFiles value column.

Online:
Once you set SourceConnection and SourceDatabaseName, the value of source database files is automatically populated.

Do you see this behavior? If not, please report what you are observing and we might be able to help.|||

Offline - I am not able to set the network share because I cannot browse (the window pops up, but there are no files to select). This may be a permission issue with the host server. I don't even know what the path would be to type it in.

Online - yes, the database name is auto-populated (or I can type it in), however when I try to run the package, validation fails because "at least one source must be selected"... Maybe I do not understand the error message, but I am assuming this is because the path to the database file is not selected ? ... even though it is greyed out. I don't know what else it could be, because everything else is populated.

Try looking at these:

http://manycounselors.com/taskdetail.jpg

http://manycounselors.com/taskerror.jpg

|||In the image taskdetail.jpg, SourceDatabaseFiles value is not set. This property is set automatically after you select the database name. If you type an invalid database name, then the source database files property is not automatically populated. I think you typed the source database name instead of selecting it from the drop-down box. You might have entered an invalid database name and your error message could be due this reason. Try selecting the source database instead of typing. (You can see the list of available databases in the server by clicking on the button that appears in the right end of the property value column. This button appears when you click on the value column.)|||

I double checked it... I am selecting the database from the drop down list. The problem is that the database source file is not being automatically selected. It stays blank. Is this only happening for me? Seems like a bug.

|||Can anyone confirm this as a bug, or tell me what I am doing wrong?|||I continue to experience this error. Can someone please help... This is a bug?!?|||I could not get to repro this in my machines? Could there be something wrong with your install? Is there another machine that you can use to repeat this behavior?|||I get exactly the same error, on a brand new install of SQL 2005 SP2 / Visual Studio 2005 SP1. I'm definitely selecting my source database from the dropdown (not typing it in) and the SourceDatabaseFiles file field is not autopopulated, whether the method is DatabaseOnline or DatabaseOffline. This seems doubly poor as I don't even *need* the source file specified to run a DatabaseOnline transfer, but nevertheless because the system fails to populate it, I can't run the package! It fails with the error message "At least one source file must be specified."

Like mpavlik above I'm left with no easy bug free way of transferring my database between servers which kind of sucks ...

Cannot transfer/copy database in one step like I could with 2000.

Hi,

I would like to know if there will every be a clean way to transfer a database from a remote server to a local server (and back again). I've tried several different approaches, but they all currently have bugs/problems.

I've looked into database publishing wizard - but this creates a huge script that takes 10x longer to run than the old DTS transfer.

I've tried copying data, and objects separate, but this requires multiple steps, using DTS this was all done in one step.

I've tried using SSIS Transfer SQL Objects, but the defaults are not created, using DTS, the ENTIRE database was transfered, which is what I want.

I've tried using SSIS Transfer Database, but even when I select "Online" mode, I get an error asking me to select at least one source file, but there is nothing to select (no files appear in the pop up window).

I've tried copy database or backup database, but I do not have suffient permission on the remote server for these.

So many different ways to do it, but all fail!

PLEASE - make a simple way to transfer a database from a remote host and back again. I want to be able to select a database source and destination and have the database copied. PLEASE - at least restore the old way until other options are working first.

mpavlik wrote:

I've tried using SSIS Transfer Database, but even when I select

"Online" mode, I get an error asking me to select at least one source

file, but there is nothing to select (no files appear in the pop up

window).

Offline:
Once you set SourceConnection and SourceDatabaseName, you should be able to set the network share for database files to be transferred by clicking on "..." in SourceDatabaseFiles value column.

Online:
Once you set SourceConnection and SourceDatabaseName, the value of source database files is automatically populated.

Do you see this behavior? If not, please report what you are observing and we might be able to help.|||

Offline - I am not able to set the network share because I cannot browse (the window pops up, but there are no files to select). This may be a permission issue with the host server. I don't even know what the path would be to type it in.

Online - yes, the database name is auto-populated (or I can type it in), however when I try to run the package, validation fails because "at least one source must be selected"... Maybe I do not understand the error message, but I am assuming this is because the path to the database file is not selected ? ... even though it is greyed out. I don't know what else it could be, because everything else is populated.

Try looking at these:

http://manycounselors.com/taskdetail.jpg

http://manycounselors.com/taskerror.jpg

|||In the image taskdetail.jpg, SourceDatabaseFiles value is not set. This property is set automatically after you select the database name. If you type an invalid database name, then the source database files property is not automatically populated. I think you typed the source database name instead of selecting it from the drop-down box. You might have entered an invalid database name and your error message could be due this reason. Try selecting the source database instead of typing. (You can see the list of available databases in the server by clicking on the button that appears in the right end of the property value column. This button appears when you click on the value column.)|||

I double checked it... I am selecting the database from the drop down list. The problem is that the database source file is not being automatically selected. It stays blank. Is this only happening for me? Seems like a bug.

|||Can anyone confirm this as a bug, or tell me what I am doing wrong?|||I continue to experience this error. Can someone please help... This is a bug?!?|||I could not get to repro this in my machines? Could there be something wrong with your install? Is there another machine that you can use to repeat this behavior?|||I get exactly the same error, on a brand new install of SQL 2005 SP2 / Visual Studio 2005 SP1. I'm definitely selecting my source database from the dropdown (not typing it in) and the SourceDatabaseFiles file field is not autopopulated, whether the method is DatabaseOnline or DatabaseOffline. This seems doubly poor as I don't even *need* the source file specified to run a DatabaseOnline transfer, but nevertheless because the system fails to populate it, I can't run the package! It fails with the error message "At least one source file must be specified."

Like mpavlik above I'm left with no easy bug free way of transferring my database between servers which kind of sucks ...

Cannot start up local server

Recently I cannot start up my local SQL 2000.
I goto services panel, select MSSQLSEREVR, right click select 'Start', got
a message box:
"The MSSQKSERVER service on Local Computer started and then stopped. Some
services stop automatically if they have no work to do, for example, the
Performance Logs and Alerts server"
I tried to start 'Performance Logs and Alerts server' and still get the same
message box.Alan
Any errors in Event Viewer
"Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
news:%238FkVwk8GHA.1252@.TK2MSFTNGP04.phx.gbl...
> Recently I cannot start up my local SQL 2000.
> I goto services panel, select MSSQLSEREVR, right click select 'Start',
> got a message box:
> "The MSSQKSERVER service on Local Computer started and then stopped. Some
> services stop automatically if they have no work to do, for example, the
> Performance Logs and Alerts server"
> I tried to start 'Performance Logs and Alerts server' and still get the
> same message box.
>|||Uri Dimant wrote:
> Alan
> Any errors in Event Viewer
>
>
> "Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
> news:%238FkVwk8GHA.1252@.TK2MSFTNGP04.phx.gbl...
> > Recently I cannot start up my local SQL 2000.
> > I goto services panel, select MSSQLSEREVR, right click select 'Start',
> > got a message box:
> > "The MSSQKSERVER service on Local Computer started and then stopped. Some
> > services stop automatically if they have no work to do, for example, the
> > Performance Logs and Alerts server"
> >
> > I tried to start 'Performance Logs and Alerts server' and still get the
> > same message box.
> >
Try to find out errors in Event Viewer or SQL Server Errorlog.
Regards
Amish Shah
http://shahamishm.tripod.com|||Sorry, how do I open the EventViewer ?
"amish" <shahamishm@.gmail.com> wrote in message
news:1161168035.474752.181820@.e3g2000cwe.googlegroups.com...
> Uri Dimant wrote:
>> Alan
>> Any errors in Event Viewer
>>
>>
>> "Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
>> news:%238FkVwk8GHA.1252@.TK2MSFTNGP04.phx.gbl...
>> > Recently I cannot start up my local SQL 2000.
>> > I goto services panel, select MSSQLSEREVR, right click select 'Start',
>> > got a message box:
>> > "The MSSQKSERVER service on Local Computer started and then stopped.
>> > Some
>> > services stop automatically if they have no work to do, for example,
>> > the
>> > Performance Logs and Alerts server"
>> >
>> > I tried to start 'Performance Logs and Alerts server' and still get the
>> > same message box.
>> >
> Try to find out errors in Event Viewer or SQL Server Errorlog.
> Regards
> Amish Shah
> http://shahamishm.tripod.com
>|||Alan T wrote:
> Sorry, how do I open the EventViewer ?
> "amish" <shahamishm@.gmail.com> wrote in message
> news:1161168035.474752.181820@.e3g2000cwe.googlegroups.com...
> >
> > Uri Dimant wrote:
> >
> >> Alan
> >>
> >> Any errors in Event Viewer
> >>
> >>
> >>
> >>
> >> "Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
> >> news:%238FkVwk8GHA.1252@.TK2MSFTNGP04.phx.gbl...
> >> > Recently I cannot start up my local SQL 2000.
> >> > I goto services panel, select MSSQLSEREVR, right click select 'Start',
> >> > got a message box:
> >> > "The MSSQKSERVER service on Local Computer started and then stopped.
> >> > Some
> >> > services stop automatically if they have no work to do, for example,
> >> > the
> >> > Performance Logs and Alerts server"
> >> >
> >> > I tried to start 'Performance Logs and Alerts server' and still get the
> >> > same message box.
> >> >
> >
> > Try to find out errors in Event Viewer or SQL Server Errorlog.
> >
> > Regards
> > Amish Shah
> > http://shahamishm.tripod.com
> >
go to start--> run
type eventvwr
Regards
Amish Shah
http://shahamishm.tripod.com|||Hi,
Yes I opened the eventviewer and knowing my evaluation copy of SQL 2000
Enterprise has expired.
Can I install the SQL 2000 Developer Edition on the top of it?
"amish" <shahamishm@.gmail.com> wrote in message
news:1161240339.590000.279530@.m7g2000cwm.googlegroups.com...
> Alan T wrote:
>> Sorry, how do I open the EventViewer ?
>> "amish" <shahamishm@.gmail.com> wrote in message
>> news:1161168035.474752.181820@.e3g2000cwe.googlegroups.com...
>> >
>> > Uri Dimant wrote:
>> >
>> >> Alan
>> >>
>> >> Any errors in Event Viewer
>> >>
>> >>
>> >>
>> >>
>> >> "Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
>> >> news:%238FkVwk8GHA.1252@.TK2MSFTNGP04.phx.gbl...
>> >> > Recently I cannot start up my local SQL 2000.
>> >> > I goto services panel, select MSSQLSEREVR, right click select
>> >> > 'Start',
>> >> > got a message box:
>> >> > "The MSSQKSERVER service on Local Computer started and then stopped.
>> >> > Some
>> >> > services stop automatically if they have no work to do, for example,
>> >> > the
>> >> > Performance Logs and Alerts server"
>> >> >
>> >> > I tried to start 'Performance Logs and Alerts server' and still get
>> >> > the
>> >> > same message box.
>> >> >
>> >
>> > Try to find out errors in Event Viewer or SQL Server Errorlog.
>> >
>> > Regards
>> > Amish Shah
>> > http://shahamishm.tripod.com
>> >
> go to start--> run
> type eventvwr
> Regards
> Amish Shah
> http://shahamishm.tripod.com
>

Cannot start up local server

Recently I cannot start up my local SQL 2000.
I goto services panel, select MSSQLSEREVR, right click select 'Start', got
a message box:
"The MSSQKSERVER service on Local Computer started and then stopped. Some
services stop automatically if they have no work to do, for example, the
Performance Logs and Alerts server"
I tried to start 'Performance Logs and Alerts server' and still get the same
message box.
Alan
Any errors in Event Viewer
"Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
news:%238FkVwk8GHA.1252@.TK2MSFTNGP04.phx.gbl...
> Recently I cannot start up my local SQL 2000.
> I goto services panel, select MSSQLSEREVR, right click select 'Start',
> got a message box:
> "The MSSQKSERVER service on Local Computer started and then stopped. Some
> services stop automatically if they have no work to do, for example, the
> Performance Logs and Alerts server"
> I tried to start 'Performance Logs and Alerts server' and still get the
> same message box.
>
|||Uri Dimant wrote:
[vbcol=seagreen]
> Alan
> Any errors in Event Viewer
>
>
> "Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
> news:%238FkVwk8GHA.1252@.TK2MSFTNGP04.phx.gbl...
Try to find out errors in Event Viewer or SQL Server Errorlog.
Regards
Amish Shah
http://shahamishm.tripod.com
|||Sorry, how do I open the EventViewer ?
"amish" <shahamishm@.gmail.com> wrote in message
news:1161168035.474752.181820@.e3g2000cwe.googlegro ups.com...
> Uri Dimant wrote:
>
> Try to find out errors in Event Viewer or SQL Server Errorlog.
> Regards
> Amish Shah
> http://shahamishm.tripod.com
>
|||Alan T wrote:
[vbcol=seagreen]
> Sorry, how do I open the EventViewer ?
> "amish" <shahamishm@.gmail.com> wrote in message
> news:1161168035.474752.181820@.e3g2000cwe.googlegro ups.com...
go to start--> run
type eventvwr
Regards
Amish Shah
http://shahamishm.tripod.com

Cannot start up local server

Recently I cannot start up my local SQL 2000.
I goto services panel, select MSSQLSEREVR, right click select 'Start', got
a message box:
"The MSSQKSERVER service on Local Computer started and then stopped. Some
services stop automatically if they have no work to do, for example, the
Performance Logs and Alerts server"
I tried to start 'Performance Logs and Alerts server' and still get the same
message box.Alan
Any errors in Event Viewer
"Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
news:%238FkVwk8GHA.1252@.TK2MSFTNGP04.phx.gbl...
> Recently I cannot start up my local SQL 2000.
> I goto services panel, select MSSQLSEREVR, right click select 'Start',
> got a message box:
> "The MSSQKSERVER service on Local Computer started and then stopped. Some
> services stop automatically if they have no work to do, for example, the
> Performance Logs and Alerts server"
> I tried to start 'Performance Logs and Alerts server' and still get the
> same message box.
>|||Uri Dimant wrote:
[vbcol=seagreen]
> Alan
> Any errors in Event Viewer
>
>
> "Alan T" <alanpltseNOSPAM@.yahoo.com.au> wrote in message
> news:%238FkVwk8GHA.1252@.TK2MSFTNGP04.phx.gbl...
Try to find out errors in Event Viewer or SQL Server Errorlog.
Regards
Amish Shah
http://shahamishm.tripod.com|||Sorry, how do I open the EventViewer ?
"amish" <shahamishm@.gmail.com> wrote in message
news:1161168035.474752.181820@.e3g2000cwe.googlegroups.com...
> Uri Dimant wrote:
>
> Try to find out errors in Event Viewer or SQL Server Errorlog.
> Regards
> Amish Shah
> http://shahamishm.tripod.com
>|||Alan T wrote:
[vbcol=seagreen]
> Sorry, how do I open the EventViewer ?
> "amish" <shahamishm@.gmail.com> wrote in message
> news:1161168035.474752.181820@.e3g2000cwe.googlegroups.com...
go to start--> run
type eventvwr
Regards
Amish Shah
http://shahamishm.tripod.com|||Hi,
Yes I opened the eventviewer and knowing my evaluation copy of SQL 2000
Enterprise has expired.
Can I install the SQL 2000 Developer Edition on the top of it?
"amish" <shahamishm@.gmail.com> wrote in message
news:1161240339.590000.279530@.m7g2000cwm.googlegroups.com...
> Alan T wrote:
>
> go to start--> run
> type eventvwr
> Regards
> Amish Shah
> http://shahamishm.tripod.com
>

Saturday, February 25, 2012

Cannot start service

I am VERY NEW to SQL server. I hope you will pardon my total ignorance.
That said:
I have installed SQL Server 2000 Developer Edition on my local PC running
Windows XP Home Edition.
From the CD I installed everything under the "SQL Server 2000 Components"
menu item on the install disk.
I now have an icon in the system tray for the SQL Server Service Manager.
When I open that icon I see a server name (the network name of my local PC,
I have 2 computers on a small network)
I see SQL Sever in the Services box.
There's a message on the bottom of that window that says:
Stopped - \\700XL - MSSQL Server (700XL is my computer name)
When I click on the Start/Continue button I get the following error message:
ERROR
The service did not start due to logon failure.
When I click OK I get the following message:
SQL Server Service Manager
An error 1069 - (The service did not start due to a logon failure.)
occurred while perfomring this service operation on teh MSSQLServer service.
According to the Enterprise Manager I am using Windows Authentication.
I don't even know where to begin. Can anyone help me please?
Thank you
MarkThis is a Windows problem. Windows tries to start the service using the
account you have specified. However, the password that Windows is using is
incorrect, so it cannot login for the service. Administrative tools,
Services, and there you need to specify the correct password for the SQL
Server service.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"markPanger" <no_spam_mpanger@.fastmail.fm> wrote in message
news:%23L1oHMD7DHA.2540@.TK2MSFTNGP11.phx.gbl...
> I am VERY NEW to SQL server. I hope you will pardon my total ignorance.
> That said:
> I have installed SQL Server 2000 Developer Edition on my local PC running
> Windows XP Home Edition.
> From the CD I installed everything under the "SQL Server 2000 Components"
> menu item on the install disk.
> I now have an icon in the system tray for the SQL Server Service Manager.
> When I open that icon I see a server name (the network name of my local
PC,
> I have 2 computers on a small network)
> I see SQL Sever in the Services box.
> There's a message on the bottom of that window that says:
> Stopped - \\700XL - MSSQL Server (700XL is my computer name)
> When I click on the Start/Continue button I get the following error
message:
> ERROR
> The service did not start due to logon failure.
> When I click OK I get the following message:
> SQL Server Service Manager
> An error 1069 - (The service did not start due to a logon
failure.)
> occurred while perfomring this service operation on teh MSSQLServer
service.
> According to the Enterprise Manager I am using Windows Authentication.
> I don't even know where to begin. Can anyone help me please?
> Thank you
> Mark
>
>
>
>|||Wohoo!! (In my best Homer Simpson voice).
When I set the MSSQL Server properties log on as "Local System account", it
worked.
I'm hoping that setting isn't going to cause me a different problem
elsewhere.
Thank you for the nearly instantaneous response,Tibor!
Mark :-)
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ODeJySD7DHA.2064@.TK2MSFTNGP11.phx.gbl...
> This is a Windows problem. Windows tries to start the service using the
> account you have specified. However, the password that Windows is using is
> incorrect, so it cannot login for the service. Administrative tools,
> Services, and there you need to specify the correct password for the SQL
> Server service.
> --
> Tibor Karaszi, SQL Server MVP
> Archive at:
>
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
>
> "markPanger" <no_spam_mpanger@.fastmail.fm> wrote in message
> news:%23L1oHMD7DHA.2540@.TK2MSFTNGP11.phx.gbl...
> > I am VERY NEW to SQL server. I hope you will pardon my total ignorance.
> >
> > That said:
> > I have installed SQL Server 2000 Developer Edition on my local PC
running
> > Windows XP Home Edition.
> >
> > From the CD I installed everything under the "SQL Server 2000
Components"
> > menu item on the install disk.
> >
> > I now have an icon in the system tray for the SQL Server Service
Manager.
> >
> > When I open that icon I see a server name (the network name of my local
> PC,
> > I have 2 computers on a small network)
> >
> > I see SQL Sever in the Services box.
> >
> > There's a message on the bottom of that window that says:
> > Stopped - \\700XL - MSSQL Server (700XL is my computer name)
> >
> > When I click on the Start/Continue button I get the following error
> message:
> > ERROR
> > The service did not start due to logon failure.
> >
> > When I click OK I get the following message:
> > SQL Server Service Manager
> > An error 1069 - (The service did not start due to a logon
> failure.)
> > occurred while perfomring this service operation on teh MSSQLServer
> service.
> >
> > According to the Enterprise Manager I am using Windows Authentication.
> >
> > I don't even know where to begin. Can anyone help me please?
> >
> > Thank you
> > Mark
> >
> >
> >
> >
> >
> >
> >
>|||> Wohoo!! (In my best Homer Simpson voice).
LOL :-)
You might want to search in Books Online for "level token". That will lead you to the section which
descries the service account, and stuff like that.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"markPanger" <no_spam_mpanger@.fastmail.fm> wrote in message
news:OnD2kkD7DHA.2556@.TK2MSFTNGP09.phx.gbl...
> Wohoo!! (In my best Homer Simpson voice).
> When I set the MSSQL Server properties log on as "Local System account", it
> worked.
> I'm hoping that setting isn't going to cause me a different problem
> elsewhere.
> Thank you for the nearly instantaneous response,Tibor!
> Mark :-)
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:ODeJySD7DHA.2064@.TK2MSFTNGP11.phx.gbl...
> > This is a Windows problem. Windows tries to start the service using the
> > account you have specified. However, the password that Windows is using is
> > incorrect, so it cannot login for the service. Administrative tools,
> > Services, and there you need to specify the correct password for the SQL
> > Server service.
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > Archive at:
> >
> http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
> >
> >
> > "markPanger" <no_spam_mpanger@.fastmail.fm> wrote in message
> > news:%23L1oHMD7DHA.2540@.TK2MSFTNGP11.phx.gbl...
> > > I am VERY NEW to SQL server. I hope you will pardon my total ignorance.
> > >
> > > That said:
> > > I have installed SQL Server 2000 Developer Edition on my local PC
> running
> > > Windows XP Home Edition.
> > >
> > > From the CD I installed everything under the "SQL Server 2000
> Components"
> > > menu item on the install disk.
> > >
> > > I now have an icon in the system tray for the SQL Server Service
> Manager.
> > >
> > > When I open that icon I see a server name (the network name of my local
> > PC,
> > > I have 2 computers on a small network)
> > >
> > > I see SQL Sever in the Services box.
> > >
> > > There's a message on the bottom of that window that says:
> > > Stopped - \\700XL - MSSQL Server (700XL is my computer name)
> > >
> > > When I click on the Start/Continue button I get the following error
> > message:
> > > ERROR
> > > The service did not start due to logon failure.
> > >
> > > When I click OK I get the following message:
> > > SQL Server Service Manager
> > > An error 1069 - (The service did not start due to a logon
> > failure.)
> > > occurred while perfomring this service operation on teh MSSQLServer
> > service.
> > >
> > > According to the Enterprise Manager I am using Windows Authentication.
> > >
> > > I don't even know where to begin. Can anyone help me please?
> > >
> > > Thank you
> > > Mark
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> >
> >
>