Alerts SP3 Vs SP4

Alerts do not seem to work on SQL Server 2000 SP4. I tested them on SQL
Server 2000 SP3 and saw an alert window pop up. Has anyone seen this problem?
Any help is appreciated.
Thanks.
You mean notification thought NET SEND? If so, verify that the windows services are started (alerter
and messenger), I believe the services are disables with more recent of OS and service pack.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"KMP" <KMP@.discussions.microsoft.com> wrote in message
news:E8985674-8B32-47BB-97D1-73894747BC75@.microsoft.com...
> Alerts do not seem to work on SQL Server 2000 SP4. I tested them on SQL
> Server 2000 SP3 and saw an alert window pop up. Has anyone seen this problem?
> Any help is appreciated.
> Thanks.
|||That was it. Thank you very much.
"Tibor Karaszi" wrote:

> You mean notification thought NET SEND? If so, verify that the windows services are started (alerter
> and messenger), I believe the services are disables with more recent of OS and service pack.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "KMP" <KMP@.discussions.microsoft.com> wrote in message
> news:E8985674-8B32-47BB-97D1-73894747BC75@.microsoft.com...
>

Alerts SP3 Vs SP4

Alerts do not seem to work on SQL Server 2000 SP4. I tested them on SQL
Server 2000 SP3 and saw an alert window pop up. Has anyone seen this problem
?
Any help is appreciated.
Thanks.You mean notification thought NET SEND? If so, verify that the windows servi
ces are started (alerter
and messenger), I believe the services are disables with more recent of OS a
nd service pack.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"KMP" <KMP@.discussions.microsoft.com> wrote in message
news:E8985674-8B32-47BB-97D1-73894747BC75@.microsoft.com...
> Alerts do not seem to work on SQL Server 2000 SP4. I tested them on SQL
> Server 2000 SP3 and saw an alert window pop up. Has anyone seen this probl
em?
> Any help is appreciated.
> Thanks.|||That was it. Thank you very much.
"Tibor Karaszi" wrote:

> You mean notification thought NET SEND? If so, verify that the windows ser
vices are started (alerter
> and messenger), I believe the services are disables with more recent of OS
and service pack.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
> "KMP" <KMP@.discussions.microsoft.com> wrote in message
> news:E8985674-8B32-47BB-97D1-73894747BC75@.microsoft.com...
>

Alert Demo: Sev. 25 Errors - Fatal Error !

Hi, All
I am using SQLserver 2000.
The SQL Server Agent -> Alert says the follower msg:
Demo, Full msbd log
Demo, Full tempdb
Demo, Sev 19Erros (019-Fatal Error in Resource)
Demo, Sev. 20 Errors (020-Fatal Error In Current Process)
....
Demo, Sev. 25 Errors (025 - Fatal Error)
What should I do with these?
Thanks a lot!!!
Michaelproperly ur disk is full, try realse some space to store tempdb's data filesql

AIX Server Client Software

I will be deploying a Java application on AIX server. Is there a SQL
Server Client Software that I need to install on the AIX server to
enable the communication between the AIX box and SQL Server?

--
Posted via http://dbforums.commalfonso (member36521@.dbforums.com) writes:
> I will be deploying a Java application on AIX server. Is there a SQL
> Server Client Software that I need to install on the AIX server to
> enable the communication between the AIX box and SQL Server?

I gathered the little I know on
http://www.algonet.se/~sommar/mssqlperl/unix.html.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

Again and Again SQLServer DB connection How?WHy

Hi All:
I really Shocked,These days I just really shocked what`s going happen behind
the WindowsSP2 and Windows Server 2003 (SP1)'
when I see that I can Connect to the MSSQL through Win2k and WinXP(SP1) But
I can`t connect through those.
We have a Software that install MSDE DB instance on the Windows
Server2003(WINXPSP2 too) and we can`t connect to that?even when attached my
DB to SqlEnterprise Manager,again I couldn`t connect through that?I really
swamp into details of Windows Firewall I`ve really done everything that MS
Say about opening port ,etc but nothing happen
Now the things that important for me is that What really happen to these 2
Goddamn Windows Security happened to them. IMHO, long overdue.
What ports have you opened?
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Hossein Kiaie" <hosseinpro@.gmail.com> wrote in message
news:uBTjkVo$FHA.3308@.TK2MSFTNGP11.phx.gbl...
> Hi All:
> I really Shocked,These days I just really shocked what`s going happen
> behind the WindowsSP2 and Windows Server 2003 (SP1)'
> when I see that I can Connect to the MSSQL through Win2k and WinXP(SP1)
> But I can`t connect through those.
> We have a Software that install MSDE DB instance on the Windows
> Server2003(WINXPSP2 too) and we can`t connect to that?even when attached
> my DB to SqlEnterprise Manager,again I couldn`t connect through that?I
> really swamp into details of Windows Firewall I`ve really done everything
> that MS Say about opening port ,etc but nothing happen
> Now the things that important for me is that What really happen to these 2
> Goddamn Windows
>|||Thanks Man:
I opened TCP and UCP 1433
But nothing Happen
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:uIX7ngo$FHA.2320@.TK2MSFTNGP11.phx.gbl...
> Security happened to them. IMHO, long overdue.
> What ports have you opened?
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Hossein Kiaie" <hosseinpro@.gmail.com> wrote in message
> news:uBTjkVo$FHA.3308@.TK2MSFTNGP11.phx.gbl...
>|||I am Sorry But Let me Explain it clearly:
1.We Have Windows Server 2003 SP1 server
2.Install Our Software that install MSDE DB instance
3.We have Client that want to connect to this but they get"Sql doesn`t
exist/access denied"
4.the point is this problem never happen with Windows XP XP1 or Windows 2000
So What Should i do Now?
Please Help ME Thanks
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:uIX7ngo$FHA.2320@.TK2MSFTNGP11.phx.gbl...
> Security happened to them. IMHO, long overdue.
> What ports have you opened?
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Hossein Kiaie" <hosseinpro@.gmail.com> wrote in message
> news:uBTjkVo$FHA.3308@.TK2MSFTNGP11.phx.gbl...
>

Again and Again SQLServer DB connection How?WHy

Hi All:
I really Shocked,These days I just really shocked what`s going happen behind
the WindowsSP2 and Windows Server 2003 (SP1)?
when I see that I can Connect to the MSSQL through Win2k and WinXP(SP1) But
I can`t connect through those.
We have a Software that install MSDE DB instance on the Windows
Server2003(WINXPSP2 too) and we can`t connect to that?even when attached my
DB to SqlEnterprise Manager,again I couldn`t connect through that?I really
swamp into details of Windows Firewall I`ve really done everything that MS
Say about opening port ,etc but nothing happen
Now the things that important for me is that What really happen to these 2
Goddamn Windows
Security happened to them. IMHO, long overdue.
What ports have you opened?
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Hossein Kiaie" <hosseinpro@.gmail.com> wrote in message
news:uBTjkVo$FHA.3308@.TK2MSFTNGP11.phx.gbl...
> Hi All:
> I really Shocked,These days I just really shocked what`s going happen
> behind the WindowsSP2 and Windows Server 2003 (SP1)?
> when I see that I can Connect to the MSSQL through Win2k and WinXP(SP1)
> But I can`t connect through those.
> We have a Software that install MSDE DB instance on the Windows
> Server2003(WINXPSP2 too) and we can`t connect to that?even when attached
> my DB to SqlEnterprise Manager,again I couldn`t connect through that?I
> really swamp into details of Windows Firewall I`ve really done everything
> that MS Say about opening port ,etc but nothing happen
> Now the things that important for me is that What really happen to these 2
> Goddamn Windows
>
|||Thanks Man:
I opened TCP and UCP 1433
But nothing Happen
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:uIX7ngo$FHA.2320@.TK2MSFTNGP11.phx.gbl...
> Security happened to them. IMHO, long overdue.
> What ports have you opened?
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Hossein Kiaie" <hosseinpro@.gmail.com> wrote in message
> news:uBTjkVo$FHA.3308@.TK2MSFTNGP11.phx.gbl...
>
|||I am Sorry But Let me Explain it clearly:
1.We Have Windows Server 2003 SP1 server
2.Install Our Software that install MSDE DB instance
3.We have Client that want to connect to this but they get"Sql doesn`t
exist/access denied"
4.the point is this problem never happen with windows XP XP1 or Windows 2000
So What Should i do Now?
Please Help ME Thanks
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:uIX7ngo$FHA.2320@.TK2MSFTNGP11.phx.gbl...
> Security happened to them. IMHO, long overdue.
> What ports have you opened?
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Hossein Kiaie" <hosseinpro@.gmail.com> wrote in message
> news:uBTjkVo$FHA.3308@.TK2MSFTNGP11.phx.gbl...
>

After restoring MASTER database, can't start SQLServer Service: Configuration block version 0 i

Now, I checked and verified that my backup version of SQL Server is the same as the version installed on the computer I'm restoring too.

I have SQL Server on a production machine that I backed up and want to test a full restore on a dev machine to make sure it will work when I need it to.

Now that I've run the restore command on my tape backup and go to restart the SQL server service I receive:

Configuration block version 0 is not a valid version number. SQL Server is exiting. Restore the master database or reinstall.

I'm afraid I don't understand why this is happening. If the builds are the same, then shouldn't restoring the MASTER database have worked normally and I'd be able to restart the service now?

Any thoughts or suggestions?

If the service cannot be started, you must rebuild the

system databases, adding information that has been lost by attaching existing tables and recreating

objects.

After this, Restoring the master database when SQL Server is accessible

With master database accessible, you should start SQL Server in single-user mode and then restore your copy of the

master database from your most recent full database backup in the usual way, as described in the

following steps.

#1 - Start SQL Server in single-user mode.

with command:

sqlservr.exe -c –m

#2 - Restore the master database from the most recent backup:

RESTORE DATABASE master

FROM masterbackup

If Master isn′t accessible:

To rebuild the master database, you should run the SQL Server setup program with the following

options:

? The /qn switch to suppress the user interface.

? The REINSTALLMODE = AMUS property to rebuild system databases.

? The REINSTALL = ALL property to set up the server with the previously installed features.

This must be used when specifying the REINSTALLMODE property.

|||

I tried rebuilding using this command:

start /wait d:\setup.exe /qb INSTANCENAME=MSSQLSERVER REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=YourPassword

However, you are saying those were not the proper commands and switches to use during the reinstallation?

(Also I didn't want to specify an SA account and password, I wanted to use windows authentication but didn't see an option for that).

|||

To use Windows authentication, you need use this parameters:

start /wait d:\setup.exe /qb INSTANCENAME=MSSQLSERVER REINSTALL=SQL_Engine REBUILDDATABASE=1

SQLACCOUNT=<domain\user> SQLPASSWORD=<DomainUserPassword>

|||

Thanks.

Anyway, I tried rebuilding and that DID work.

But when I restored the master database, I was back where I started.

I KNOW the database installations are the same version as I did SELECT @.@.VERSION on both and they match.

So I don't understand why restoring a tape from one server to the other causes the other server to throw this error when the versions of the server do appear to be the same.

After rename the computer

Hi,
I have rename my WindowsXP after I installing the SqlServer 2005 express.
Can the SqlServer run well in the WindowsXP after renaming?you want to drop the old sqlserver name and add the new one.
exec sp_dropserver 'oldcomputername\sqlexpress'
go
exec sp_addserver 'newcomputername\sqlexpress','local'
go
restart sqlserver service to take effect.
-oj
"ad" <flying@.wfes.tcc.edu.tw> wrote in message
news:OYygEeAlGHA.1456@.TK2MSFTNGP04.phx.gbl...
> Hi,
> I have rename my WindowsXP after I installing the SqlServer 2005 express.
> Can the SqlServer run well in the WindowsXP after renaming?
>|||i think we need to update originating_server in sysjobs after change server
name?
else the job won't run..
DECLARE @.srv sysnameSET @.srv = CAST(SERVERPROPERTY('ServerName') AS sysname)
UPDATE sysjobs SET originating_server = @.srv
"oj" wrote:

> you want to drop the old sqlserver name and add the new one.
> exec sp_dropserver 'oldcomputername\sqlexpress'
> go
> exec sp_addserver 'newcomputername\sqlexpress','local'
> go
> restart sqlserver service to take effect.
> --
> -oj
>
> "ad" <flying@.wfes.tcc.edu.tw> wrote in message
> news:OYygEeAlGHA.1456@.TK2MSFTNGP04.phx.gbl...
>
>|||you want to drop the old sqlserver name and add the new one.
exec sp_dropserver 'oldcomputername\sqlexpress'
go
exec sp_addserver 'newcomputername\sqlexpress','local'
go
restart sqlserver service to take effect.
-oj
"ad" <flying@.wfes.tcc.edu.tw> wrote in message
news:OYygEeAlGHA.1456@.TK2MSFTNGP04.phx.gbl...
> Hi,
> I have rename my WindowsXP after I installing the SqlServer 2005 express.
> Can the SqlServer run well in the WindowsXP after renaming?
>|||i think we need to update originating_server in sysjobs after change server
name?
else the job won't run..
DECLARE @.srv sysnameSET @.srv = CAST(SERVERPROPERTY('ServerName') AS sysname)
UPDATE sysjobs SET originating_server = @.srv
"oj" wrote:

> you want to drop the old sqlserver name and add the new one.
> exec sp_dropserver 'oldcomputername\sqlexpress'
> go
> exec sp_addserver 'newcomputername\sqlexpress','local'
> go
> restart sqlserver service to take effect.
> --
> -oj
>
> "ad" <flying@.wfes.tcc.edu.tw> wrote in message
> news:OYygEeAlGHA.1456@.TK2MSFTNGP04.phx.gbl...
>
>|||indeed. also, you will not be able to drop the old name (unless you hack the
sysservers table) if you have replication, loopback linked server setup.
-oj
"soonyu" <soonyu@.discussions.microsoft.com> wrote in message
news:096BBAB9-19AC-44B8-9E5E-1924FA71F61C@.microsoft.com...[vbcol=seagreen]
>i think we need to update originating_server in sysjobs after change
>server
> name?
> else the job won't run..
> DECLARE @.srv sysnameSET @.srv = CAST(SERVERPROPERTY('ServerName') AS
> sysname)
> UPDATE sysjobs SET originating_server = @.srv
>
> "oj" wrote:
>|||indeed. also, you will not be able to drop the old name (unless you hack the
sysservers table) if you have replication, loopback linked server setup.
-oj
"soonyu" <soonyu@.discussions.microsoft.com> wrote in message
news:096BBAB9-19AC-44B8-9E5E-1924FA71F61C@.microsoft.com...[vbcol=seagreen]
>i think we need to update originating_server in sysjobs after change
>server
> name?
> else the job won't run..
> DECLARE @.srv sysnameSET @.srv = CAST(SERVERPROPERTY('ServerName') AS
> sysname)
> UPDATE sysjobs SET originating_server = @.srv
>
> "oj" wrote:
>

After rename the computer

Hi,
I have rename my WindowsXP after I installing the SqlServer 2005 express.
Can the SqlServer run well in the WindowsXP after renaming?you want to drop the old sqlserver name and add the new one.
exec sp_dropserver 'oldcomputername\sqlexpress'
go
exec sp_addserver 'newcomputername\sqlexpress','local'
go
restart sqlserver service to take effect.
--
-oj
"ad" <flying@.wfes.tcc.edu.tw> wrote in message
news:OYygEeAlGHA.1456@.TK2MSFTNGP04.phx.gbl...
> Hi,
> I have rename my WindowsXP after I installing the SqlServer 2005 express.
> Can the SqlServer run well in the WindowsXP after renaming?
>|||i think we need to update originating_server in sysjobs after change server
name?
else the job won't run..
DECLARE @.srv sysnameSET @.srv = CAST(SERVERPROPERTY('ServerName') AS sysname)
UPDATE sysjobs SET originating_server = @.srv
"oj" wrote:
> you want to drop the old sqlserver name and add the new one.
> exec sp_dropserver 'oldcomputername\sqlexpress'
> go
> exec sp_addserver 'newcomputername\sqlexpress','local'
> go
> restart sqlserver service to take effect.
> --
> -oj
>
> "ad" <flying@.wfes.tcc.edu.tw> wrote in message
> news:OYygEeAlGHA.1456@.TK2MSFTNGP04.phx.gbl...
> > Hi,
> >
> > I have rename my WindowsXP after I installing the SqlServer 2005 express.
> >
> > Can the SqlServer run well in the WindowsXP after renaming?
> >
> >
>
>|||indeed. also, you will not be able to drop the old name (unless you hack the
sysservers table) if you have replication, loopback linked server setup.
--
-oj
"soonyu" <soonyu@.discussions.microsoft.com> wrote in message
news:096BBAB9-19AC-44B8-9E5E-1924FA71F61C@.microsoft.com...
>i think we need to update originating_server in sysjobs after change
>server
> name?
> else the job won't run..
> DECLARE @.srv sysnameSET @.srv = CAST(SERVERPROPERTY('ServerName') AS
> sysname)
> UPDATE sysjobs SET originating_server = @.srv
>
> "oj" wrote:
>> you want to drop the old sqlserver name and add the new one.
>> exec sp_dropserver 'oldcomputername\sqlexpress'
>> go
>> exec sp_addserver 'newcomputername\sqlexpress','local'
>> go
>> restart sqlserver service to take effect.
>> --
>> -oj
>>
>> "ad" <flying@.wfes.tcc.edu.tw> wrote in message
>> news:OYygEeAlGHA.1456@.TK2MSFTNGP04.phx.gbl...
>> > Hi,
>> >
>> > I have rename my WindowsXP after I installing the SqlServer 2005
>> > express.
>> >
>> > Can the SqlServer run well in the WindowsXP after renaming?
>> >
>> >
>>

After changing the comupter's name

I installed SQL Server 2005 in a windows xp machine. The ogrinal name of the machine is pc1.
After installing SqlServer 2005, I change the machine name to pc2.

I find that many login names in the Manager Studio is still prefixed with pc1, like pc1/ASPNET.

Must I change the prefix to pc2 manually?Yes, you will need to update the login names.

I discussed this issue and a possible solution on my blog at:

http://blogs.msdn.com/lcris/archive/2005/09/27/474505.aspx

Let me know if you need additional help.

Thanks
Laurentiu

After change the computer name.

I installed SQL Server 2005 in a windows xp machine. The ogrinal name of the
machine is pc1.
After installing SqlServer 2005, I change the machine name to pc2.
I find that many login names in the Manager Studio is still prefixed with
pc1, like pc1/ASPNET.
Must I change the prefix to pc2 manually?
Hello, ad
See: http://msdn2.microsoft.com/en-us/library/ms143799.aspx
Razvan

After change the computer name.

I installed SQL Server 2005 in a windows xp machine. The ogrinal name of the
machine is pc1.
After installing SqlServer 2005, I change the machine name to pc2.
I find that many login names in the Manager Studio is still prefixed with
pc1, like pc1/ASPNET.
Must I change the prefix to pc2 manually?Hello, ad
See: http://msdn2.microsoft.com/en-us/library/ms143799.aspx
Razvan

After change the computer name.

I installed SQL Server 2005 in a Windows XP machine. The ogrinal name of the
machine is pc1.
After installing SqlServer 2005, I change the machine name to pc2.
I find that many login names in the Manager Studio is still prefixed with
pc1, like pc1/ASPNET.
Must I change the prefix to pc2 manually?Hello, ad
See: http://msdn2.microsoft.com/en-us/library/ms143799.aspx
Razvan