First is can I use Windows XP with the client tools (Enterprise Manager) to
connect to MS SQL Server 2000? If so, can someone explaine? I have tried
using SQL Server Authentication but I get an error saying server does not
exit or access denied. I tried using the SA account and that does not work
either.
Thanks,Yes you should be able to . One gotcha is that XP Home always
authenticates as Guest.
Create a Test ODBC DSN to get a better error message if you can't connect.
Check the OS error number.
Example:
OS Error 10061 = Connection Refused. Server is not listening on the socket.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
Showing posts with label enterprise. Show all posts
Showing posts with label enterprise. Show all posts
Thursday, March 22, 2012
Can not connect to MS SQL server 2000 with Windows XP
First is can I use Windows XP with the client tools (Enterprise Manager) to
connect to MS SQL Server 2000? If so, can someone explaine? I have tried
using SQL Server Authentication but I get an error saying server does not
exit or access denied. I tried using the SA account and that does not work
either.
Thanks,
Yes you should be able to . One gotcha is that XP Home always
authenticates as Guest.
Create a Test ODBC DSN to get a better error message if you can't connect.
Check the OS error number.
Example:
OS Error 10061 = Connection Refused. Server is not listening on the socket.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
connect to MS SQL Server 2000? If so, can someone explaine? I have tried
using SQL Server Authentication but I get an error saying server does not
exit or access denied. I tried using the SA account and that does not work
either.
Thanks,
Yes you should be able to . One gotcha is that XP Home always
authenticates as Guest.
Create a Test ODBC DSN to get a better error message if you can't connect.
Check the OS error number.
Example:
OS Error 10061 = Connection Refused. Server is not listening on the socket.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
Monday, March 19, 2012
Can MSDE Do Log Shipping?
The subject line pretty much says it all. I'be been trying to use the SQL
Enterprise Administrator that came with SQL 2000 Enterprise to configure log
shipping, but the checkbox does not appear for databases on my MSDE servers,
only for the databases on my SQL 2000 Standard servers. Is there a way to set
up log shipping with MSDE?
--EricYes and no.
Log shipping is built in to Enterprise Edition only. However, there is
nothing preventing you from writing your own or using a third-party Log
Shipping solution with MSDE. The SQL 2000 Resource Kit even has an example.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"Eric Robinson" <eric@._nospam_nvipa.com> wrote in message
news:CFN379450764603357@.news.microsoft.com...
> The subject line pretty much says it all. I'be been trying to use the SQL
> Enterprise Administrator that came with SQL 2000 Enterprise to configure
log
> shipping, but the checkbox does not appear for databases on my MSDE
servers,
> only for the databases on my SQL 2000 Standard servers. Is there a way to
set
> up log shipping with MSDE?
> --Eric|||To expand on Geoff's post, here is a site that you may find helpful:
http://sqlguy.home.comcast.net/logship.htm
-- Keith
"Eric Robinson" <eric@._nospam_nvipa.com> wrote in message =news:CFN379450764603357@.news.microsoft.com...
> The subject line pretty much says it all. I'be been trying to use the =SQL > Enterprise Administrator that came with SQL 2000 Enterprise to =configure log > shipping, but the checkbox does not appear for databases on my MSDE =servers, > only for the databases on my SQL 2000 Standard servers. Is there a way =to set > up log shipping with MSDE?
> > --Eric
Enterprise Administrator that came with SQL 2000 Enterprise to configure log
shipping, but the checkbox does not appear for databases on my MSDE servers,
only for the databases on my SQL 2000 Standard servers. Is there a way to set
up log shipping with MSDE?
--EricYes and no.
Log shipping is built in to Enterprise Edition only. However, there is
nothing preventing you from writing your own or using a third-party Log
Shipping solution with MSDE. The SQL 2000 Resource Kit even has an example.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"Eric Robinson" <eric@._nospam_nvipa.com> wrote in message
news:CFN379450764603357@.news.microsoft.com...
> The subject line pretty much says it all. I'be been trying to use the SQL
> Enterprise Administrator that came with SQL 2000 Enterprise to configure
log
> shipping, but the checkbox does not appear for databases on my MSDE
servers,
> only for the databases on my SQL 2000 Standard servers. Is there a way to
set
> up log shipping with MSDE?
> --Eric|||To expand on Geoff's post, here is a site that you may find helpful:
http://sqlguy.home.comcast.net/logship.htm
-- Keith
"Eric Robinson" <eric@._nospam_nvipa.com> wrote in message =news:CFN379450764603357@.news.microsoft.com...
> The subject line pretty much says it all. I'be been trying to use the =SQL > Enterprise Administrator that came with SQL 2000 Enterprise to =configure log > shipping, but the checkbox does not appear for databases on my MSDE =servers, > only for the databases on my SQL 2000 Standard servers. Is there a way =to set > up log shipping with MSDE?
> > --Eric
Wednesday, March 7, 2012
can i use SQL server 2005 standard to create and host db for website?
Hi guys,
I am just wondering what's the difference of sql server 2005 standard and enterprise editions. can I use SQL server 2005 to host a database for a website?
Thanks!
Daren
You can find an overview of the features on the Microsoft website (here).
Hosting a database for a website on a Standard Edition is perfectly possible. Enterprise Edition is for really large environments, so if you are expecting millions of hits per day it might be better to use EE because of it's extra features for high level/load databases. But a lot of databases will run just fine on Standard Edition.
|||thanks for the feedback!
Saturday, February 25, 2012
Can I use Enterprise Manager to manage MSSQL 2005 express?
Can I use the regular Enterprise Manager to manage MSSQL 2005 express or do
I have to use the Express Manager?
SQL Server 2000 Enterprise Manager does not have support for new SQL Server
2005 features. Express Manager is being replaced with a new Express version
of the SQL Server Management Studio tool introduced in SQL Server 2005. You
can get a Customer Technical Preview version of Management Studio Express
from here:
http://www.microsoft.com/downloads/d...displaylang=en
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
This posting is provided "AS IS" with no warranties, and confers no rights.
I have to use the Express Manager?
SQL Server 2000 Enterprise Manager does not have support for new SQL Server
2005 features. Express Manager is being replaced with a new Express version
of the SQL Server Management Studio tool introduced in SQL Server 2005. You
can get a Customer Technical Preview version of Management Studio Express
from here:
http://www.microsoft.com/downloads/d...displaylang=en
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
This posting is provided "AS IS" with no warranties, and confers no rights.
Can I use data drive subscription on a remote sql standard version
I would like to upgrade our report server to sql 2000 enterprise
edition to be able to use the DD subscriptions.. if I do do upgrade the
server, will I be able to connect to a sql server on another box with
the standard version and continue to use DD subscriptions on that
remote server.
or is there another way to get around this issue by way of stored
procedures.. thanks.What specifically do you mean by "continue to use DD susbscriptions no that
remote server"? Do you mean the remote server is the source of data that
drives the DD subscription? In that case, yes.
-Tim
"Joaquin" <joaquin.pineda@.gmail.com> wrote in message
news:1147897141.934976.263120@.38g2000cwa.googlegroups.com...
>I would like to upgrade our report server to sql 2000 enterprise
> edition to be able to use the DD subscriptions.. if I do do upgrade the
> server, will I be able to connect to a sql server on another box with
> the standard version and continue to use DD subscriptions on that
> remote server.
> or is there another way to get around this issue by way of stored
> procedures.. thanks.
>|||Tim Dot NoSpam wrote:
> What specifically do you mean by "continue to use DD susbscriptions no that
> remote server"? Do you mean the remote server is the source of data that
> drives the DD subscription? In that case, yes.
>
Tim, you got it, that's what I wanted to know. also, do you know if its
possible to simulate dd subscriptions, let say by way of stored proc?
on standard version of sql. thanks.
edition to be able to use the DD subscriptions.. if I do do upgrade the
server, will I be able to connect to a sql server on another box with
the standard version and continue to use DD subscriptions on that
remote server.
or is there another way to get around this issue by way of stored
procedures.. thanks.What specifically do you mean by "continue to use DD susbscriptions no that
remote server"? Do you mean the remote server is the source of data that
drives the DD subscription? In that case, yes.
-Tim
"Joaquin" <joaquin.pineda@.gmail.com> wrote in message
news:1147897141.934976.263120@.38g2000cwa.googlegroups.com...
>I would like to upgrade our report server to sql 2000 enterprise
> edition to be able to use the DD subscriptions.. if I do do upgrade the
> server, will I be able to connect to a sql server on another box with
> the standard version and continue to use DD subscriptions on that
> remote server.
> or is there another way to get around this issue by way of stored
> procedures.. thanks.
>|||Tim Dot NoSpam wrote:
> What specifically do you mean by "continue to use DD susbscriptions no that
> remote server"? Do you mean the remote server is the source of data that
> drives the DD subscription? In that case, yes.
>
Tim, you got it, that's what I wanted to know. also, do you know if its
possible to simulate dd subscriptions, let say by way of stored proc?
on standard version of sql. thanks.
Can I use a computed column for this?
I have a table with two integers and I want another computed column like so
IIF ( colX >= colY, 1, 0 )
but enterprise manager keeps telling me there is an error in my Formula but
I do not see what it could be.
the computed column is defined to be an int
thanks,
J> but enterprise manager keeps telling me there is an error in my Formula
Egads, why are you using Enterprise Manager for this? Try Query Analyzer.
CREATE TABLE dbo.foo
(
x INT,
y INT,
z AS CONVERT(INT, CASE WHEN x >= y THEN 1 ELSE 0 END)
)
Also, not sure why you want to use INT. This could easily be BIT or TINYINT
if it is only ever going to contain two possible values.|||there is no IIF() in SQL - it's CASE
case when colx>=coly then 1 else 0 end
james wrote:
>I have a table with two integers and I want another computed column like so
>IIF ( colX >= colY, 1, 0 )
>but enterprise manager keeps telling me there is an error in my Formula but
>I do not see what it could be.
>the computed column is defined to be an int
>thanks,
>J
>
>|||James,
Use a "case" expression.
select colX, colY, case when colX >= colY then 1 else 0 end as colZ
from t1
AMB
"james" wrote:
> I have a table with two integers and I want another computed column like s
o
> IIF ( colX >= colY, 1, 0 )
> but enterprise manager keeps telling me there is an error in my Formula bu
t
> I do not see what it could be.
> the computed column is defined to be an int
> thanks,
> J
>
>|||CASE WHEN colx >= coly THEN 1 ELSE 0 END
Why would you put such a thing in a computed column? Put it in a view or
query rather than clutter your table with redundant information.
David Portas
SQL Server MVP
--|||Thanks Aaron, and all the other responses. All your comments are helpful
JIM
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:%23GfaOmjuFHA.2076@.TK2MSFTNGP14.phx.gbl...
> Egads, why are you using Enterprise Manager for this? Try Query Analyzer.
> CREATE TABLE dbo.foo
> (
> x INT,
> y INT,
> z AS CONVERT(INT, CASE WHEN x >= y THEN 1 ELSE 0 END)
> )
> Also, not sure why you want to use INT. This could easily be BIT or
> TINYINT if it is only ever going to contain two possible values.
>
IIF ( colX >= colY, 1, 0 )
but enterprise manager keeps telling me there is an error in my Formula but
I do not see what it could be.
the computed column is defined to be an int
thanks,
J> but enterprise manager keeps telling me there is an error in my Formula
Egads, why are you using Enterprise Manager for this? Try Query Analyzer.
CREATE TABLE dbo.foo
(
x INT,
y INT,
z AS CONVERT(INT, CASE WHEN x >= y THEN 1 ELSE 0 END)
)
Also, not sure why you want to use INT. This could easily be BIT or TINYINT
if it is only ever going to contain two possible values.|||there is no IIF() in SQL - it's CASE
case when colx>=coly then 1 else 0 end
james wrote:
>I have a table with two integers and I want another computed column like so
>IIF ( colX >= colY, 1, 0 )
>but enterprise manager keeps telling me there is an error in my Formula but
>I do not see what it could be.
>the computed column is defined to be an int
>thanks,
>J
>
>|||James,
Use a "case" expression.
select colX, colY, case when colX >= colY then 1 else 0 end as colZ
from t1
AMB
"james" wrote:
> I have a table with two integers and I want another computed column like s
o
> IIF ( colX >= colY, 1, 0 )
> but enterprise manager keeps telling me there is an error in my Formula bu
t
> I do not see what it could be.
> the computed column is defined to be an int
> thanks,
> J
>
>|||CASE WHEN colx >= coly THEN 1 ELSE 0 END
Why would you put such a thing in a computed column? Put it in a view or
query rather than clutter your table with redundant information.
David Portas
SQL Server MVP
--|||Thanks Aaron, and all the other responses. All your comments are helpful
JIM
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:%23GfaOmjuFHA.2076@.TK2MSFTNGP14.phx.gbl...
> Egads, why are you using Enterprise Manager for this? Try Query Analyzer.
> CREATE TABLE dbo.foo
> (
> x INT,
> y INT,
> z AS CONVERT(INT, CASE WHEN x >= y THEN 1 ELSE 0 END)
> )
> Also, not sure why you want to use INT. This could easily be BIT or
> TINYINT if it is only ever going to contain two possible values.
>
Friday, February 24, 2012
can i upgrade from sql 2005 express to sql server 2005 enterprise edition ?
if i upgrade from sql server 2005 expressto sql server 2005 enterprise can i do it ?
am i need to uninstall 2005 express before ?
am i need to uninstall 2005 express before ?
hi,
as per ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/702359c4-6ca9-42a8-860c-a95a802898a1.htm help topic of Books OnLine, you can upgrade to all 32bit editions of SQL Server 2005, including
SQL Server 2005 Enterprise Edition
SQL Server 2005 Developer Edition
SQL Server 2005 Standard Edition
SQL Server 2005 Workgroup Edition
SQL Server 2005 Express Edition with Advanced Services
a similar matrix is available on www.microsoft.com/sql sub area too, but at the moment it seems I'm unable to access Microsoft web site..
regards
Tuesday, February 14, 2012
Can I register SQL 2005 Server in the SQL 2000 Enterprise Manager?
Hi All,
I was wondering if I could register SQL 2005 Server in the SQL 2000
Enterprise Manager or vice versa.
I have two database servers. One of them is SQL 2000 enterprise edition
and the other one is SQL 2005 developer edition. We have not moved
completely to our new server from our old SQL 2000 server as we are
still learning and testing features.
I will highly appreciate your suggestions.
Thanks a million in advance.
Best regards,
MamunYou can manager 2000 and 2005 in 2005 Management Studio.
You can manage 7.0 and 2000 in 2000 Enterprise Manager.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"microsoft.public.dotnet.languages.vb" <mamun_ah@.hotmail.com> wrote in messa
ge
news:1144955476.589607.315160@.v46g2000cwv.googlegroups.com...
> Hi All,
> I was wondering if I could register SQL 2005 Server in the SQL 2000
> Enterprise Manager or vice versa.
> I have two database servers. One of them is SQL 2000 enterprise edition
> and the other one is SQL 2005 developer edition. We have not moved
> completely to our new server from our old SQL 2000 server as we are
> still learning and testing features.
> I will highly appreciate your suggestions.
> Thanks a million in advance.
> Best regards,
> Mamun
>|||You are suggested to use SQL Server Management Studio as it supports SQL
2000 and provides better perfomance when compared to the Enterprise Manager
in SQL 2000.
Martin C K Poon
Senior Analyst Programmer
====================================
"microsoft.public.dotnet.languages.vb" <mamun_ah@.hotmail.com> ?
news:1144955476.589607.315160@.v46g2000cwv.googlegroups.com ?...
> Hi All,
> I was wondering if I could register SQL 2005 Server in the SQL 2000
> Enterprise Manager or vice versa.
> I have two database servers. One of them is SQL 2000 enterprise edition
> and the other one is SQL 2005 developer edition. We have not moved
> completely to our new server from our old SQL 2000 server as we are
> still learning and testing features.
> I will highly appreciate your suggestions.
> Thanks a million in advance.
> Best regards,
> Mamun
>
I was wondering if I could register SQL 2005 Server in the SQL 2000
Enterprise Manager or vice versa.
I have two database servers. One of them is SQL 2000 enterprise edition
and the other one is SQL 2005 developer edition. We have not moved
completely to our new server from our old SQL 2000 server as we are
still learning and testing features.
I will highly appreciate your suggestions.
Thanks a million in advance.
Best regards,
MamunYou can manager 2000 and 2005 in 2005 Management Studio.
You can manage 7.0 and 2000 in 2000 Enterprise Manager.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"microsoft.public.dotnet.languages.vb" <mamun_ah@.hotmail.com> wrote in messa
ge
news:1144955476.589607.315160@.v46g2000cwv.googlegroups.com...
> Hi All,
> I was wondering if I could register SQL 2005 Server in the SQL 2000
> Enterprise Manager or vice versa.
> I have two database servers. One of them is SQL 2000 enterprise edition
> and the other one is SQL 2005 developer edition. We have not moved
> completely to our new server from our old SQL 2000 server as we are
> still learning and testing features.
> I will highly appreciate your suggestions.
> Thanks a million in advance.
> Best regards,
> Mamun
>|||You are suggested to use SQL Server Management Studio as it supports SQL
2000 and provides better perfomance when compared to the Enterprise Manager
in SQL 2000.
Martin C K Poon
Senior Analyst Programmer
====================================
"microsoft.public.dotnet.languages.vb" <mamun_ah@.hotmail.com> ?
news:1144955476.589607.315160@.v46g2000cwv.googlegroups.com ?...
> Hi All,
> I was wondering if I could register SQL 2005 Server in the SQL 2000
> Enterprise Manager or vice versa.
> I have two database servers. One of them is SQL 2000 enterprise edition
> and the other one is SQL 2005 developer edition. We have not moved
> completely to our new server from our old SQL 2000 server as we are
> still learning and testing features.
> I will highly appreciate your suggestions.
> Thanks a million in advance.
> Best regards,
> Mamun
>
Friday, February 10, 2012
Can I Install SQL Server Reporting Services on a Domain Controller
I've just got RS Enterprise Edition.
Installed it in a Test Server, ok.
Installed it in a DEV server, having some errors.
My DEV server is an "ALL in 1" server, which is also a Domian Controller.
While Test Server is not a DC.
The installation was succesful but when I open RS Manager thru the web, it gives me a ASP.NET error:
Access to the path "D:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportManager\bin" is denied.
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.UnauthorizedAccessException: Access to the path "D:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportManager\bin" is denied.
ASP.NET is not authorized to access the requested resource. Consider granting access rights to the resource to the ASP.NET request identity. ASP.NET has a base process identity (typically {MACHINE}\ASPNET on IIS 5 or Network Service on IIS 6) that is used if the application is not impersonating. If the application is impersonating via <identity impersonate="true"/>, the identity will be the anonymous user (typically IUSR_MACHINENAME) or the authenticated request user.
To grant ASP.NET write access to a file, right-click the file in Explorer, choose "Properties" and select the Security tab. Click "Add" to add the appropriate user or group. Highlight the ASP.NET account, and check the boxes for the desired access.
I tried doing everything I can possible think of from the error message advice, including adding rights to ASPNET user from ISS to that particular folder...no success.
What I'm suspecting is I can't install RS in a DC box. But I can't find this info anyway in the web.
Anyone can point me to the correct direction or any advice?Anybody have any ideas?
( the trouble with posting a topic in another time zone...sigh*)|||I've not installed RS on a DC, but I suspect that your problem may be traced to a security/permissions issue.
Check the permissions for the folder where RS is installed. See who's on the ACL. In particular (see the error message), look for ASP.NET. ASP.NET no doesn't necessarily run as an anonymous user (depending on how you set it up). You may need to play around with the permissions some before you get it all down.
Recall that a DC has elevated security settings as compared to member servers.
I have installed RS successfully on three computers (two member servers and my laptop) with no significant issues. I don't think the issue is one of the DC, but rather permissions in general and the elevated security settings for a DC.
Regards,
hmscott
Installed it in a Test Server, ok.
Installed it in a DEV server, having some errors.
My DEV server is an "ALL in 1" server, which is also a Domian Controller.
While Test Server is not a DC.
The installation was succesful but when I open RS Manager thru the web, it gives me a ASP.NET error:
Access to the path "D:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportManager\bin" is denied.
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.UnauthorizedAccessException: Access to the path "D:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportManager\bin" is denied.
ASP.NET is not authorized to access the requested resource. Consider granting access rights to the resource to the ASP.NET request identity. ASP.NET has a base process identity (typically {MACHINE}\ASPNET on IIS 5 or Network Service on IIS 6) that is used if the application is not impersonating. If the application is impersonating via <identity impersonate="true"/>, the identity will be the anonymous user (typically IUSR_MACHINENAME) or the authenticated request user.
To grant ASP.NET write access to a file, right-click the file in Explorer, choose "Properties" and select the Security tab. Click "Add" to add the appropriate user or group. Highlight the ASP.NET account, and check the boxes for the desired access.
I tried doing everything I can possible think of from the error message advice, including adding rights to ASPNET user from ISS to that particular folder...no success.
What I'm suspecting is I can't install RS in a DC box. But I can't find this info anyway in the web.
Anyone can point me to the correct direction or any advice?Anybody have any ideas?
( the trouble with posting a topic in another time zone...sigh*)|||I've not installed RS on a DC, but I suspect that your problem may be traced to a security/permissions issue.
Check the permissions for the folder where RS is installed. See who's on the ACL. In particular (see the error message), look for ASP.NET. ASP.NET no doesn't necessarily run as an anonymous user (depending on how you set it up). You may need to play around with the permissions some before you get it all down.
Recall that a DC has elevated security settings as compared to member servers.
I have installed RS successfully on three computers (two member servers and my laptop) with no significant issues. I don't think the issue is one of the DC, but rather permissions in general and the elevated security settings for a DC.
Regards,
hmscott
Subscribe to:
Posts (Atom)