I have installed this software:
- Windows Server 2003, Enterprise Edition.
- SQL Server 2005, Client tools (Server is in an another machine)
- VirusScan Enterprise 8.0.0
When i execute the next query:
USE AdventureWorks
SELECT * FROM Person.Contact
WHERE ContactID = 1 FOR XML AUTO
VirusScan report me this:
Pathname: C:\Documents and Settings\<user>\Local Settings\Temp\tmp5B.tmp
Detected As: Exploit-ObscuredHtml
Detection Type: Trojan
Application: SqlWb.exe
And SQL Server Management Studio:
An error occurred while executing batch. Error message is: Invalid calling
sequence: file stream must be initialized first.
*****
I apreciate any sugestion !
Thank you.I turn off the antivirus and the query work,
I reported the problem to McAfee...
"Ubeimar Vergara" wrote:
> I have installed this software:
> - Windows Server 2003, Enterprise Edition.
> - SQL Server 2005, Client tools (Server is in an another machine)
> - VirusScan Enterprise 8.0.0
> When i execute the next query:
> USE AdventureWorks
> SELECT * FROM Person.Contact
> WHERE ContactID = 1 FOR XML AUTO
> VirusScan report me this:
> Pathname: C:\Documents and Settings\<user>\Local Settings\Temp\tmp5B.tmp
> Detected As: Exploit-ObscuredHtml
> Detection Type: Trojan
> Application: SqlWb.exe
> And SQL Server Management Studio:
> An error occurred while executing batch. Error message is: Invalid calling
> sequence: file stream must be initialized first.
> *****
> I apreciate any sugestion !
> Thank you.
Showing posts with label installed. Show all posts
Showing posts with label installed. Show all posts
Tuesday, March 20, 2012
BUG: using FOR XML AUTO
I have installed this software:
- Windows Server 2003, Enterprise Edition.
- SQL Server 2005, Client tools (Server is in an another machine)
- VirusScan Enterprise 8.0.0
When i execute the next query:
USE AdventureWorks
SELECT * FROM Person.Contact
WHERE ContactID = 1 FOR XML AUTO
VirusScan report me this:
Pathname: C:\Documents and Settings\<user>\Local Settings\Temp\tmp5B.tmp
Detected As: Exploit-ObscuredHtml
Detection Type: Trojan
Application: SqlWb.exe
And SQL Server Management Studio:
An error occurred while executing batch. Error message is: Invalid calling
sequence: file stream must be initialized first.
*****
I apreciate any sugestion !
Thank you.TURN OFF anti-virus software on the server!!
A properly configured SQL Server 'should' not need anti-virus software
installed on the server.
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Ubeimar Vergara" <Ubeimar Vergara@.discussions.microsoft.com> wrote in
message news:9CD7E5A0-C308-44C6-A3EA-A0B4CC2D346F@.microsoft.com...
>I have installed this software:
> - Windows Server 2003, Enterprise Edition.
> - SQL Server 2005, Client tools (Server is in an another machine)
> - VirusScan Enterprise 8.0.0
> When i execute the next query:
> USE AdventureWorks
> SELECT * FROM Person.Contact
> WHERE ContactID = 1 FOR XML AUTO
> VirusScan report me this:
> Pathname: C:\Documents and Settings\<user>\Local Settings\Temp\tmp5B.tmp
> Detected As: Exploit-ObscuredHtml
> Detection Type: Trojan
> Application: SqlWb.exe
> And SQL Server Management Studio:
> An error occurred while executing batch. Error message is: Invalid calling
> sequence: file stream must be initialized first.
> *****
> I apreciate any sugestion !
> Thank you.|||"Ubeimar Vergara" <Ubeimar Vergara@.discussions.microsoft.com> wrote in
message news:9CD7E5A0-C308-44C6-A3EA-A0B4CC2D346F@.microsoft.com...
>I have installed this software:
> - Windows Server 2003, Enterprise Edition.
> - SQL Server 2005, Client tools (Server is in an another machine)
> - VirusScan Enterprise 8.0.0
> When i execute the next query:
> USE AdventureWorks
> SELECT * FROM Person.Contact
> WHERE ContactID = 1 FOR XML AUTO
> VirusScan report me this:
> Pathname: C:\Documents and Settings\<user>\Local Settings\Temp\tmp5B.tmp
> Detected As: Exploit-ObscuredHtml
> Detection Type: Trojan
> Application: SqlWb.exe
> And SQL Server Management Studio:
> An error occurred while executing batch. Error message is: Invalid calling
> sequence: file stream must be initialized first.
>
Sounds like a bug in your Antivirus program interfering with the operation
of Management Studio on your client computer.
David|||I turn off the antivirus and the query work,
I reported the problem to McAfee...
"Ubeimar Vergara" wrote:
> I have installed this software:
> - Windows Server 2003, Enterprise Edition.
> - SQL Server 2005, Client tools (Server is in an another machine)
> - VirusScan Enterprise 8.0.0
> When i execute the next query:
> USE AdventureWorks
> SELECT * FROM Person.Contact
> WHERE ContactID = 1 FOR XML AUTO
> VirusScan report me this:
> Pathname: C:\Documents and Settings\<user>\Local Settings\Temp\tmp5B.tmp
> Detected As: Exploit-ObscuredHtml
> Detection Type: Trojan
> Application: SqlWb.exe
> And SQL Server Management Studio:
> An error occurred while executing batch. Error message is: Invalid calling
> sequence: file stream must be initialized first.
> *****
> I apreciate any sugestion !
> Thank you.sql
- Windows Server 2003, Enterprise Edition.
- SQL Server 2005, Client tools (Server is in an another machine)
- VirusScan Enterprise 8.0.0
When i execute the next query:
USE AdventureWorks
SELECT * FROM Person.Contact
WHERE ContactID = 1 FOR XML AUTO
VirusScan report me this:
Pathname: C:\Documents and Settings\<user>\Local Settings\Temp\tmp5B.tmp
Detected As: Exploit-ObscuredHtml
Detection Type: Trojan
Application: SqlWb.exe
And SQL Server Management Studio:
An error occurred while executing batch. Error message is: Invalid calling
sequence: file stream must be initialized first.
*****
I apreciate any sugestion !
Thank you.TURN OFF anti-virus software on the server!!
A properly configured SQL Server 'should' not need anti-virus software
installed on the server.
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Ubeimar Vergara" <Ubeimar Vergara@.discussions.microsoft.com> wrote in
message news:9CD7E5A0-C308-44C6-A3EA-A0B4CC2D346F@.microsoft.com...
>I have installed this software:
> - Windows Server 2003, Enterprise Edition.
> - SQL Server 2005, Client tools (Server is in an another machine)
> - VirusScan Enterprise 8.0.0
> When i execute the next query:
> USE AdventureWorks
> SELECT * FROM Person.Contact
> WHERE ContactID = 1 FOR XML AUTO
> VirusScan report me this:
> Pathname: C:\Documents and Settings\<user>\Local Settings\Temp\tmp5B.tmp
> Detected As: Exploit-ObscuredHtml
> Detection Type: Trojan
> Application: SqlWb.exe
> And SQL Server Management Studio:
> An error occurred while executing batch. Error message is: Invalid calling
> sequence: file stream must be initialized first.
> *****
> I apreciate any sugestion !
> Thank you.|||"Ubeimar Vergara" <Ubeimar Vergara@.discussions.microsoft.com> wrote in
message news:9CD7E5A0-C308-44C6-A3EA-A0B4CC2D346F@.microsoft.com...
>I have installed this software:
> - Windows Server 2003, Enterprise Edition.
> - SQL Server 2005, Client tools (Server is in an another machine)
> - VirusScan Enterprise 8.0.0
> When i execute the next query:
> USE AdventureWorks
> SELECT * FROM Person.Contact
> WHERE ContactID = 1 FOR XML AUTO
> VirusScan report me this:
> Pathname: C:\Documents and Settings\<user>\Local Settings\Temp\tmp5B.tmp
> Detected As: Exploit-ObscuredHtml
> Detection Type: Trojan
> Application: SqlWb.exe
> And SQL Server Management Studio:
> An error occurred while executing batch. Error message is: Invalid calling
> sequence: file stream must be initialized first.
>
Sounds like a bug in your Antivirus program interfering with the operation
of Management Studio on your client computer.
David|||I turn off the antivirus and the query work,
I reported the problem to McAfee...
"Ubeimar Vergara" wrote:
> I have installed this software:
> - Windows Server 2003, Enterprise Edition.
> - SQL Server 2005, Client tools (Server is in an another machine)
> - VirusScan Enterprise 8.0.0
> When i execute the next query:
> USE AdventureWorks
> SELECT * FROM Person.Contact
> WHERE ContactID = 1 FOR XML AUTO
> VirusScan report me this:
> Pathname: C:\Documents and Settings\<user>\Local Settings\Temp\tmp5B.tmp
> Detected As: Exploit-ObscuredHtml
> Detection Type: Trojan
> Application: SqlWb.exe
> And SQL Server Management Studio:
> An error occurred while executing batch. Error message is: Invalid calling
> sequence: file stream must be initialized first.
> *****
> I apreciate any sugestion !
> Thank you.sql
Sunday, March 11, 2012
Bug in vstudio SP6
Hi
Since I installed vstudio SP6 all my Sql Server diagrams only show a blank
page
Any fixes?
I have confirmed this bug on four different machines. Unfortunately, I
can't seem to find a non-paid bug support form on the MS Support site any
longer (since I no longer work for a gold partner).
What I can add is that you can still look at diagrams on your local sql
server. You can also look at the diagram in Visual Studio.Net in a database
project. My advice is that if you are not using .Net and VSS BOTH, do NOT
apply this service pack as it appears to largely be for .Net integration.
-Chip
"Stephan Brunner" <s_orbit@.hotmail.com> wrote in message
news:e9BEcvsJEHA.3292@.TK2MSFTNGP11.phx.gbl...
> Hi
> Since I installed vstudio SP6 all my Sql Server diagrams only show a blank
> page
> Any fixes?
>
|||> From: "Chip Downs" <chip@.nospamdownsnospam.org>
> References: <e9BEcvsJEHA.3292@.TK2MSFTNGP11.phx.gbl>
> Subject: Re: Bug in vstudio SP6
> Date: Wed, 5 May 2004 11:43:17 -0400
> I have confirmed this bug on four different machines. Unfortunately, I
> can't seem to find a non-paid bug support form on the MS Support site any
> longer (since I no longer work for a gold partner).
> What I can add is that you can still look at diagrams on your local sql
> server. You can also look at the diagram in Visual Studio.Net in a
database[vbcol=seagreen]
> project. My advice is that if you are not using .Net and VSS BOTH, do NOT
> apply this service pack as it appears to largely be for .Net integration.
> -Chip
> "Stephan Brunner" <s_orbit@.hotmail.com> wrote in message
> news:e9BEcvsJEHA.3292@.TK2MSFTNGP11.phx.gbl...
blank
>
Hi Chip,
Do you have a particular bug ID for this? I haven't been able to track down
a bug ID for this issue.
If you have no bug ID, would you kindly post the steps to reproduce this
problem. I will gladly file a bug for this and request for a fix.
Hope this helps,
Eric Crdenas
SQL Server senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.
Since I installed vstudio SP6 all my Sql Server diagrams only show a blank
page
Any fixes?
I have confirmed this bug on four different machines. Unfortunately, I
can't seem to find a non-paid bug support form on the MS Support site any
longer (since I no longer work for a gold partner).
What I can add is that you can still look at diagrams on your local sql
server. You can also look at the diagram in Visual Studio.Net in a database
project. My advice is that if you are not using .Net and VSS BOTH, do NOT
apply this service pack as it appears to largely be for .Net integration.
-Chip
"Stephan Brunner" <s_orbit@.hotmail.com> wrote in message
news:e9BEcvsJEHA.3292@.TK2MSFTNGP11.phx.gbl...
> Hi
> Since I installed vstudio SP6 all my Sql Server diagrams only show a blank
> page
> Any fixes?
>
|||> From: "Chip Downs" <chip@.nospamdownsnospam.org>
> References: <e9BEcvsJEHA.3292@.TK2MSFTNGP11.phx.gbl>
> Subject: Re: Bug in vstudio SP6
> Date: Wed, 5 May 2004 11:43:17 -0400
> I have confirmed this bug on four different machines. Unfortunately, I
> can't seem to find a non-paid bug support form on the MS Support site any
> longer (since I no longer work for a gold partner).
> What I can add is that you can still look at diagrams on your local sql
> server. You can also look at the diagram in Visual Studio.Net in a
database[vbcol=seagreen]
> project. My advice is that if you are not using .Net and VSS BOTH, do NOT
> apply this service pack as it appears to largely be for .Net integration.
> -Chip
> "Stephan Brunner" <s_orbit@.hotmail.com> wrote in message
> news:e9BEcvsJEHA.3292@.TK2MSFTNGP11.phx.gbl...
blank
>
Hi Chip,
Do you have a particular bug ID for this? I haven't been able to track down
a bug ID for this issue.
If you have no bug ID, would you kindly post the steps to reproduce this
problem. I will gladly file a bug for this and request for a fix.
Hope this helps,
Eric Crdenas
SQL Server senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.
Bug in vstudio SP6
Hi
Since I installed vstudio SP6 all my Sql Server diagrams only show a blank
page
Any fixes?I have confirmed this bug on four different machines. Unfortunately, I
can't seem to find a non-paid bug support form on the MS Support site any
longer (since I no longer work for a gold partner).
What I can add is that you can still look at diagrams on your local sql
server. You can also look at the diagram in Visual Studio.Net in a database
project. My advice is that if you are not using .Net and VSS BOTH, do NOT
apply this service pack as it appears to largely be for .Net integration.
-Chip
"Stephan Brunner" <s_orbit@.hotmail.com> wrote in message
news:e9BEcvsJEHA.3292@.TK2MSFTNGP11.phx.gbl...
> Hi
> Since I installed vstudio SP6 all my Sql Server diagrams only show a blank
> page
> Any fixes?
>|||> From: "Chip Downs" <chip@.nospamdownsnospam.org>
> References: <e9BEcvsJEHA.3292@.TK2MSFTNGP11.phx.gbl>
> Subject: Re: Bug in vstudio SP6
> Date: Wed, 5 May 2004 11:43:17 -0400
> I have confirmed this bug on four different machines. Unfortunately, I
> can't seem to find a non-paid bug support form on the MS Support site any
> longer (since I no longer work for a gold partner).
> What I can add is that you can still look at diagrams on your local sql
> server. You can also look at the diagram in Visual Studio.Net in a
database
> project. My advice is that if you are not using .Net and VSS BOTH, do NOT
> apply this service pack as it appears to largely be for .Net integration.
> -Chip
> "Stephan Brunner" <s_orbit@.hotmail.com> wrote in message
> news:e9BEcvsJEHA.3292@.TK2MSFTNGP11.phx.gbl...
blank[vbcol=seagreen]
>
--
Hi Chip,
Do you have a particular bug ID for this? I haven't been able to track down
a bug ID for this issue.
If you have no bug ID, would you kindly post the steps to reproduce this
problem. I will gladly file a bug for this and request for a fix.
Hope this helps,
Eric Crdenas
SQL Server senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.
Since I installed vstudio SP6 all my Sql Server diagrams only show a blank
page
Any fixes?I have confirmed this bug on four different machines. Unfortunately, I
can't seem to find a non-paid bug support form on the MS Support site any
longer (since I no longer work for a gold partner).
What I can add is that you can still look at diagrams on your local sql
server. You can also look at the diagram in Visual Studio.Net in a database
project. My advice is that if you are not using .Net and VSS BOTH, do NOT
apply this service pack as it appears to largely be for .Net integration.
-Chip
"Stephan Brunner" <s_orbit@.hotmail.com> wrote in message
news:e9BEcvsJEHA.3292@.TK2MSFTNGP11.phx.gbl...
> Hi
> Since I installed vstudio SP6 all my Sql Server diagrams only show a blank
> page
> Any fixes?
>|||> From: "Chip Downs" <chip@.nospamdownsnospam.org>
> References: <e9BEcvsJEHA.3292@.TK2MSFTNGP11.phx.gbl>
> Subject: Re: Bug in vstudio SP6
> Date: Wed, 5 May 2004 11:43:17 -0400
> I have confirmed this bug on four different machines. Unfortunately, I
> can't seem to find a non-paid bug support form on the MS Support site any
> longer (since I no longer work for a gold partner).
> What I can add is that you can still look at diagrams on your local sql
> server. You can also look at the diagram in Visual Studio.Net in a
database
> project. My advice is that if you are not using .Net and VSS BOTH, do NOT
> apply this service pack as it appears to largely be for .Net integration.
> -Chip
> "Stephan Brunner" <s_orbit@.hotmail.com> wrote in message
> news:e9BEcvsJEHA.3292@.TK2MSFTNGP11.phx.gbl...
blank[vbcol=seagreen]
>
--
Hi Chip,
Do you have a particular bug ID for this? I haven't been able to track down
a bug ID for this issue.
If you have no bug ID, would you kindly post the steps to reproduce this
problem. I will gladly file a bug for this and request for a fix.
Hope this helps,
Eric Crdenas
SQL Server senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.
Bug in vstudio SP6
Hi
Since I installed vstudio SP6 all my Sql Server diagrams only show a blank
page
Any fixes?I have confirmed this bug on four different machines. Unfortunately, I
can't seem to find a non-paid bug support form on the MS Support site any
longer (since I no longer work for a gold partner).
What I can add is that you can still look at diagrams on your local sql
server. You can also look at the diagram in Visual Studio.Net in a database
project. My advice is that if you are not using .Net and VSS BOTH, do NOT
apply this service pack as it appears to largely be for .Net integration.
-Chip
"Stephan Brunner" <s_orbit@.hotmail.com> wrote in message
news:e9BEcvsJEHA.3292@.TK2MSFTNGP11.phx.gbl...
> Hi
> Since I installed vstudio SP6 all my Sql Server diagrams only show a blank
> page
> Any fixes?
>|||> From: "Chip Downs" <chip@.nospamdownsnospam.org>
> References: <e9BEcvsJEHA.3292@.TK2MSFTNGP11.phx.gbl>
> Subject: Re: Bug in vstudio SP6
> Date: Wed, 5 May 2004 11:43:17 -0400
> I have confirmed this bug on four different machines. Unfortunately, I
> can't seem to find a non-paid bug support form on the MS Support site any
> longer (since I no longer work for a gold partner).
> What I can add is that you can still look at diagrams on your local sql
> server. You can also look at the diagram in Visual Studio.Net in a
database
> project. My advice is that if you are not using .Net and VSS BOTH, do NOT
> apply this service pack as it appears to largely be for .Net integration.
> -Chip
> "Stephan Brunner" <s_orbit@.hotmail.com> wrote in message
> news:e9BEcvsJEHA.3292@.TK2MSFTNGP11.phx.gbl...
> > Hi
> >
> > Since I installed vstudio SP6 all my Sql Server diagrams only show a
blank
> > page
> >
> > Any fixes?
>
--
Hi Chip,
Do you have a particular bug ID for this? I haven't been able to track down
a bug ID for this issue.
If you have no bug ID, would you kindly post the steps to reproduce this
problem. I will gladly file a bug for this and request for a fix.
Hope this helps,
--
Eric Cárdenas
SQL Server senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.
Since I installed vstudio SP6 all my Sql Server diagrams only show a blank
page
Any fixes?I have confirmed this bug on four different machines. Unfortunately, I
can't seem to find a non-paid bug support form on the MS Support site any
longer (since I no longer work for a gold partner).
What I can add is that you can still look at diagrams on your local sql
server. You can also look at the diagram in Visual Studio.Net in a database
project. My advice is that if you are not using .Net and VSS BOTH, do NOT
apply this service pack as it appears to largely be for .Net integration.
-Chip
"Stephan Brunner" <s_orbit@.hotmail.com> wrote in message
news:e9BEcvsJEHA.3292@.TK2MSFTNGP11.phx.gbl...
> Hi
> Since I installed vstudio SP6 all my Sql Server diagrams only show a blank
> page
> Any fixes?
>|||> From: "Chip Downs" <chip@.nospamdownsnospam.org>
> References: <e9BEcvsJEHA.3292@.TK2MSFTNGP11.phx.gbl>
> Subject: Re: Bug in vstudio SP6
> Date: Wed, 5 May 2004 11:43:17 -0400
> I have confirmed this bug on four different machines. Unfortunately, I
> can't seem to find a non-paid bug support form on the MS Support site any
> longer (since I no longer work for a gold partner).
> What I can add is that you can still look at diagrams on your local sql
> server. You can also look at the diagram in Visual Studio.Net in a
database
> project. My advice is that if you are not using .Net and VSS BOTH, do NOT
> apply this service pack as it appears to largely be for .Net integration.
> -Chip
> "Stephan Brunner" <s_orbit@.hotmail.com> wrote in message
> news:e9BEcvsJEHA.3292@.TK2MSFTNGP11.phx.gbl...
> > Hi
> >
> > Since I installed vstudio SP6 all my Sql Server diagrams only show a
blank
> > page
> >
> > Any fixes?
>
--
Hi Chip,
Do you have a particular bug ID for this? I haven't been able to track down
a bug ID for this issue.
If you have no bug ID, would you kindly post the steps to reproduce this
problem. I will gladly file a bug for this and request for a fix.
Hope this helps,
--
Eric Cárdenas
SQL Server senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.
Friday, February 24, 2012
Browser problem?
I've installed SQL Server 2005 Express on Windows 2000 server. I've enabled
tcp/ip for remote connections. I also have SQL Server 7 on the same server.
I can connect to the SQL Server Express instance remotely if I specify the
dynamic port:
sqlcmd -S<ip address>\sqlexpress,<port number> -Usa -Ppassword
I've started SQL Server Browser and tried to connect without specifying the
dynamic port but it doesn't work?
What am I doing wrong?
What are the specific error messages, numbers when you can't
connect?
-Sue
On Tue, 17 Oct 2006 05:11:02 -0700, Axel
<Axel@.discussions.microsoft.com> wrote:
>I've installed SQL Server 2005 Express on Windows 2000 server. I've enabled
>tcp/ip for remote connections. I also have SQL Server 7 on the same server.
>I can connect to the SQL Server Express instance remotely if I specify the
>dynamic port:
>sqlcmd -S<ip address>\sqlexpress,<port number> -Usa -Ppassword
>I've started SQL Server Browser and tried to connect without specifying the
>dynamic port but it doesn't work?
>What am I doing wrong?
tcp/ip for remote connections. I also have SQL Server 7 on the same server.
I can connect to the SQL Server Express instance remotely if I specify the
dynamic port:
sqlcmd -S<ip address>\sqlexpress,<port number> -Usa -Ppassword
I've started SQL Server Browser and tried to connect without specifying the
dynamic port but it doesn't work?
What am I doing wrong?
What are the specific error messages, numbers when you can't
connect?
-Sue
On Tue, 17 Oct 2006 05:11:02 -0700, Axel
<Axel@.discussions.microsoft.com> wrote:
>I've installed SQL Server 2005 Express on Windows 2000 server. I've enabled
>tcp/ip for remote connections. I also have SQL Server 7 on the same server.
>I can connect to the SQL Server Express instance remotely if I specify the
>dynamic port:
>sqlcmd -S<ip address>\sqlexpress,<port number> -Usa -Ppassword
>I've started SQL Server Browser and tried to connect without specifying the
>dynamic port but it doesn't work?
>What am I doing wrong?
Browser problem?
I've installed SQL Server 2005 Express on Windows 2000 server. I've enabled
tcp/ip for remote connections. I also have SQL Server 7 on the same server.
I can connect to the SQL Server Express instance remotely if I specify the
dynamic port:
sqlcmd -S<ip address>\sqlexpress,<port number> -Usa -Ppassword
I've started SQL Server Browser and tried to connect without specifying the
dynamic port but it doesn't work?
What am I doing wrong?What are the specific error messages, numbers when you can't
connect?
-Sue
On Tue, 17 Oct 2006 05:11:02 -0700, Axel
<Axel@.discussions.microsoft.com> wrote:
>I've installed SQL Server 2005 Express on Windows 2000 server. I've enabled
>tcp/ip for remote connections. I also have SQL Server 7 on the same server.
>I can connect to the SQL Server Express instance remotely if I specify the
>dynamic port:
>sqlcmd -S<ip address>\sqlexpress,<port number> -Usa -Ppassword
>I've started SQL Server Browser and tried to connect without specifying the
>dynamic port but it doesn't work?
>What am I doing wrong?
tcp/ip for remote connections. I also have SQL Server 7 on the same server.
I can connect to the SQL Server Express instance remotely if I specify the
dynamic port:
sqlcmd -S<ip address>\sqlexpress,<port number> -Usa -Ppassword
I've started SQL Server Browser and tried to connect without specifying the
dynamic port but it doesn't work?
What am I doing wrong?What are the specific error messages, numbers when you can't
connect?
-Sue
On Tue, 17 Oct 2006 05:11:02 -0700, Axel
<Axel@.discussions.microsoft.com> wrote:
>I've installed SQL Server 2005 Express on Windows 2000 server. I've enabled
>tcp/ip for remote connections. I also have SQL Server 7 on the same server.
>I can connect to the SQL Server Express instance remotely if I specify the
>dynamic port:
>sqlcmd -S<ip address>\sqlexpress,<port number> -Usa -Ppassword
>I've started SQL Server Browser and tried to connect without specifying the
>dynamic port but it doesn't work?
>What am I doing wrong?
Sunday, February 19, 2012
broke sql server...please help
so i installed sql server and i was using it within enterprise manager. Then it broke when i started trying to make my web application connect to my database. So my connection string was:
server=(local);database=capacity;User ID=dbo;trusted_connection=False
i got this error: Login failed for user 'dbo'. Reason: Not associated with a trusted SQL Server connection.
so i tried messing around with the string and found something online that said i should right click the server (local) and go to the security settings and change it to mixed mode, sql server authentication AND windows authentication. Before it was just windows authentication. So i did that...and now i get this error when i try to open up my server in enterprise manager:
A connection could not be established to (local)
Reason: Login failed for user 'samr'. Reason Not associated with a trusted SQL Server Connection..
Please verify SQL Server is running (which it is) and check your SQL server registration properties by right clicking on the local node and try again.
i can right click on it, but whenever i do anything (go to properties, click the '+' icon) i get this message:
Connection failed. Check sql server registration properties.
please help...
should i delete the registration and just start over...?
why couldnt i connect into sql server...?Take a look @.INF: Windows Authentication is the Default Security Mode After a SQL Server 2000 Typical Installation
Broadcast Storm
I have a SQL server 2000 with service pack 3 installed.
This morning I saw that its CPU utilization is about 98%
and it was broadcasting something to all network
computers.
I checked for any virus but nothing found.
Could you help me?It's most likely slammer. Have a look here:
http://www.aspfaq.com/show.asp?id=2440 SQL Slammer info
--
Andrew J. Kelly
SQL Server MVP
"payman" <paymanzafar@.yahoo.com> wrote in message
news:05fe01c3b0d0$7d80e030$a401280a@.phx.gbl...
> I have a SQL server 2000 with service pack 3 installed.
> This morning I saw that its CPU utilization is about 98%
> and it was broadcasting something to all network
> computers.
> I checked for any virus but nothing found.
> Could you help me?
This morning I saw that its CPU utilization is about 98%
and it was broadcasting something to all network
computers.
I checked for any virus but nothing found.
Could you help me?It's most likely slammer. Have a look here:
http://www.aspfaq.com/show.asp?id=2440 SQL Slammer info
--
Andrew J. Kelly
SQL Server MVP
"payman" <paymanzafar@.yahoo.com> wrote in message
news:05fe01c3b0d0$7d80e030$a401280a@.phx.gbl...
> I have a SQL server 2000 with service pack 3 installed.
> This morning I saw that its CPU utilization is about 98%
> and it was broadcasting something to all network
> computers.
> I checked for any virus but nothing found.
> Could you help me?
British English Date Problem - ISO-dates not accepted (64-bit)
Problem exists on a 64-bit SQL Server (although the same result occurs on a
32-bit platform), where we have installed MS-SQL with the British English
locale.
We are experiencing problems when passing ISO format dates (yyyy-mm-dd)
within queries. UK date format (25/12/2004) are ok but as soon as an iso
date is used '2004-12-25' an error occurs.
<For example:>
Select * from tbltest where testdate > '2003-04-16 00:00:00'
<Returns error:>
Server: Msg 296, Level 16, State 3, Line 1
The conversion of char data type to smalldatetime data type resulted in an
out-of-range smalldatetime value.
There must be something that we are missing here, as changing the users
locale to the default 'English' (US English) corrects the problem.
Thanks in advance
IanHave a look at these:
http://www.karaszi.com/SQLServer/info_datetime.asp Guide to Datetimes
http://www.sqlservercentral.com/columnists/bsyverson/sqldatetime.asp
Datetimes
http://www.murach.com/books/sqls/article.htm Datetime Searching
I would use the format of 'yyyymmdd' instead.
--
Andrew J. Kelly SQL MVP
"Ian" <Ian@.discussions.microsoft.com> wrote in message
news:77EB65F8-40FE-4BE6-9058-425CFA1F36B8@.microsoft.com...
> Problem exists on a 64-bit SQL Server (although the same result occurs on
> a
> 32-bit platform), where we have installed MS-SQL with the British English
> locale.
> We are experiencing problems when passing ISO format dates (yyyy-mm-dd)
> within queries. UK date format (25/12/2004) are ok but as soon as an iso
> date is used '2004-12-25' an error occurs.
> <For example:>
> Select * from tbltest where testdate > '2003-04-16 00:00:00'
> <Returns error:>
> Server: Msg 296, Level 16, State 3, Line 1
> The conversion of char data type to smalldatetime data type resulted in an
> out-of-range smalldatetime value.
> There must be something that we are missing here, as changing the users
> locale to the default 'English' (US English) corrects the problem.
> Thanks in advance
> Ian|||thanks for the info...
Ian
"Andrew J. Kelly" wrote:
> Have a look at these:
>
> http://www.karaszi.com/SQLServer/info_datetime.asp Guide to Datetimes
> http://www.sqlservercentral.com/columnists/bsyverson/sqldatetime.asp
> Datetimes
> http://www.murach.com/books/sqls/article.htm Datetime Searching
>
> I would use the format of 'yyyymmdd' instead.
> --
> Andrew J. Kelly SQL MVP
>
> "Ian" <Ian@.discussions.microsoft.com> wrote in message
> news:77EB65F8-40FE-4BE6-9058-425CFA1F36B8@.microsoft.com...
> > Problem exists on a 64-bit SQL Server (although the same result occurs on
> > a
> > 32-bit platform), where we have installed MS-SQL with the British English
> > locale.
> >
> > We are experiencing problems when passing ISO format dates (yyyy-mm-dd)
> > within queries. UK date format (25/12/2004) are ok but as soon as an iso
> > date is used '2004-12-25' an error occurs.
> >
> > <For example:>
> >
> > Select * from tbltest where testdate > '2003-04-16 00:00:00'
> >
> > <Returns error:>
> >
> > Server: Msg 296, Level 16, State 3, Line 1
> > The conversion of char data type to smalldatetime data type resulted in an
> > out-of-range smalldatetime value.
> >
> > There must be something that we are missing here, as changing the users
> > locale to the default 'English' (US English) corrects the problem.
> >
> > Thanks in advance
> > Ian
>
>
32-bit platform), where we have installed MS-SQL with the British English
locale.
We are experiencing problems when passing ISO format dates (yyyy-mm-dd)
within queries. UK date format (25/12/2004) are ok but as soon as an iso
date is used '2004-12-25' an error occurs.
<For example:>
Select * from tbltest where testdate > '2003-04-16 00:00:00'
<Returns error:>
Server: Msg 296, Level 16, State 3, Line 1
The conversion of char data type to smalldatetime data type resulted in an
out-of-range smalldatetime value.
There must be something that we are missing here, as changing the users
locale to the default 'English' (US English) corrects the problem.
Thanks in advance
IanHave a look at these:
http://www.karaszi.com/SQLServer/info_datetime.asp Guide to Datetimes
http://www.sqlservercentral.com/columnists/bsyverson/sqldatetime.asp
Datetimes
http://www.murach.com/books/sqls/article.htm Datetime Searching
I would use the format of 'yyyymmdd' instead.
--
Andrew J. Kelly SQL MVP
"Ian" <Ian@.discussions.microsoft.com> wrote in message
news:77EB65F8-40FE-4BE6-9058-425CFA1F36B8@.microsoft.com...
> Problem exists on a 64-bit SQL Server (although the same result occurs on
> a
> 32-bit platform), where we have installed MS-SQL with the British English
> locale.
> We are experiencing problems when passing ISO format dates (yyyy-mm-dd)
> within queries. UK date format (25/12/2004) are ok but as soon as an iso
> date is used '2004-12-25' an error occurs.
> <For example:>
> Select * from tbltest where testdate > '2003-04-16 00:00:00'
> <Returns error:>
> Server: Msg 296, Level 16, State 3, Line 1
> The conversion of char data type to smalldatetime data type resulted in an
> out-of-range smalldatetime value.
> There must be something that we are missing here, as changing the users
> locale to the default 'English' (US English) corrects the problem.
> Thanks in advance
> Ian|||thanks for the info...
Ian
"Andrew J. Kelly" wrote:
> Have a look at these:
>
> http://www.karaszi.com/SQLServer/info_datetime.asp Guide to Datetimes
> http://www.sqlservercentral.com/columnists/bsyverson/sqldatetime.asp
> Datetimes
> http://www.murach.com/books/sqls/article.htm Datetime Searching
>
> I would use the format of 'yyyymmdd' instead.
> --
> Andrew J. Kelly SQL MVP
>
> "Ian" <Ian@.discussions.microsoft.com> wrote in message
> news:77EB65F8-40FE-4BE6-9058-425CFA1F36B8@.microsoft.com...
> > Problem exists on a 64-bit SQL Server (although the same result occurs on
> > a
> > 32-bit platform), where we have installed MS-SQL with the British English
> > locale.
> >
> > We are experiencing problems when passing ISO format dates (yyyy-mm-dd)
> > within queries. UK date format (25/12/2004) are ok but as soon as an iso
> > date is used '2004-12-25' an error occurs.
> >
> > <For example:>
> >
> > Select * from tbltest where testdate > '2003-04-16 00:00:00'
> >
> > <Returns error:>
> >
> > Server: Msg 296, Level 16, State 3, Line 1
> > The conversion of char data type to smalldatetime data type resulted in an
> > out-of-range smalldatetime value.
> >
> > There must be something that we are missing here, as changing the users
> > locale to the default 'English' (US English) corrects the problem.
> >
> > Thanks in advance
> > Ian
>
>
British English Date Problem - ISO-dates not accepted (64-bit)
Problem exists on a 64-bit SQL Server (although the same result occurs on a
32-bit platform), where we have installed MS-SQL with the British English
locale.
We are experiencing problems when passing ISO format dates (yyyy-mm-dd)
within queries. UK date format (25/12/2004) are ok but as soon as an iso
date is used '2004-12-25' an error occurs.
<For example:>
Select * from tbltest where testdate > '2003-04-16 00:00:00'
<Returns error:>
Server: Msg 296, Level 16, State 3, Line 1
The conversion of char data type to smalldatetime data type resulted in an
out-of-range smalldatetime value.
There must be something that we are missing here, as changing the users
locale to the default 'English' (US English) corrects the problem.
Thanks in advance
Ian
Have a look at these:
http://www.karaszi.com/SQLServer/info_datetime.asp Guide to Datetimes
http://www.sqlservercentral.com/colu...qldatetime.asp
Datetimes
http://www.murach.com/books/sqls/article.htm Datetime Searching
I would use the format of 'yyyymmdd' instead.
Andrew J. Kelly SQL MVP
"Ian" <Ian@.discussions.microsoft.com> wrote in message
news:77EB65F8-40FE-4BE6-9058-425CFA1F36B8@.microsoft.com...
> Problem exists on a 64-bit SQL Server (although the same result occurs on
> a
> 32-bit platform), where we have installed MS-SQL with the British English
> locale.
> We are experiencing problems when passing ISO format dates (yyyy-mm-dd)
> within queries. UK date format (25/12/2004) are ok but as soon as an iso
> date is used '2004-12-25' an error occurs.
> <For example:>
> Select * from tbltest where testdate > '2003-04-16 00:00:00'
> <Returns error:>
> Server: Msg 296, Level 16, State 3, Line 1
> The conversion of char data type to smalldatetime data type resulted in an
> out-of-range smalldatetime value.
> There must be something that we are missing here, as changing the users
> locale to the default 'English' (US English) corrects the problem.
> Thanks in advance
> Ian
|||thanks for the info...
Ian
"Andrew J. Kelly" wrote:
> Have a look at these:
>
> http://www.karaszi.com/SQLServer/info_datetime.asp Guide to Datetimes
> http://www.sqlservercentral.com/colu...qldatetime.asp
> Datetimes
> http://www.murach.com/books/sqls/article.htm Datetime Searching
>
> I would use the format of 'yyyymmdd' instead.
> --
> Andrew J. Kelly SQL MVP
>
> "Ian" <Ian@.discussions.microsoft.com> wrote in message
> news:77EB65F8-40FE-4BE6-9058-425CFA1F36B8@.microsoft.com...
>
>
32-bit platform), where we have installed MS-SQL with the British English
locale.
We are experiencing problems when passing ISO format dates (yyyy-mm-dd)
within queries. UK date format (25/12/2004) are ok but as soon as an iso
date is used '2004-12-25' an error occurs.
<For example:>
Select * from tbltest where testdate > '2003-04-16 00:00:00'
<Returns error:>
Server: Msg 296, Level 16, State 3, Line 1
The conversion of char data type to smalldatetime data type resulted in an
out-of-range smalldatetime value.
There must be something that we are missing here, as changing the users
locale to the default 'English' (US English) corrects the problem.
Thanks in advance
Ian
Have a look at these:
http://www.karaszi.com/SQLServer/info_datetime.asp Guide to Datetimes
http://www.sqlservercentral.com/colu...qldatetime.asp
Datetimes
http://www.murach.com/books/sqls/article.htm Datetime Searching
I would use the format of 'yyyymmdd' instead.
Andrew J. Kelly SQL MVP
"Ian" <Ian@.discussions.microsoft.com> wrote in message
news:77EB65F8-40FE-4BE6-9058-425CFA1F36B8@.microsoft.com...
> Problem exists on a 64-bit SQL Server (although the same result occurs on
> a
> 32-bit platform), where we have installed MS-SQL with the British English
> locale.
> We are experiencing problems when passing ISO format dates (yyyy-mm-dd)
> within queries. UK date format (25/12/2004) are ok but as soon as an iso
> date is used '2004-12-25' an error occurs.
> <For example:>
> Select * from tbltest where testdate > '2003-04-16 00:00:00'
> <Returns error:>
> Server: Msg 296, Level 16, State 3, Line 1
> The conversion of char data type to smalldatetime data type resulted in an
> out-of-range smalldatetime value.
> There must be something that we are missing here, as changing the users
> locale to the default 'English' (US English) corrects the problem.
> Thanks in advance
> Ian
|||thanks for the info...
Ian
"Andrew J. Kelly" wrote:
> Have a look at these:
>
> http://www.karaszi.com/SQLServer/info_datetime.asp Guide to Datetimes
> http://www.sqlservercentral.com/colu...qldatetime.asp
> Datetimes
> http://www.murach.com/books/sqls/article.htm Datetime Searching
>
> I would use the format of 'yyyymmdd' instead.
> --
> Andrew J. Kelly SQL MVP
>
> "Ian" <Ian@.discussions.microsoft.com> wrote in message
> news:77EB65F8-40FE-4BE6-9058-425CFA1F36B8@.microsoft.com...
>
>
Sunday, February 12, 2012
BPA Feedback and Question
I've been exploring the best practices tool and find most things great! I have installed it on multiple machines and then changed the database that each client logs into to be the same one so that we have one central repository and it seems to be working
well. I would like to see a way to schedule a job that would run the scans at off hours since we are trying to make it mandatory for our developers to run a clean scan before they move out of our development environment. I was also surprised when i not
iced that there were no stored procedures in the slqbpa database, isn't that going against best practices ;)
Debi
In the released version there will be a command line version that will let
you use sql agent or some other scheduler to do what you want.
About stored procedures... not that strictly a best practice... depends on
your application or on what you're trying to do. The extensible architecture
of bpa called for some adhoc query building which may be better in the app
than doing dynamic sql inside stored procs. That said, I would like to see
some of the logic moved to stored procs, post v1. In the pre-7.0 days,
stored procs were way more a perf best practice.
- Christian
___________________________
Christian Kleinerman
Program Manager, SQL Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Debi" <anonymous@.discussions.microsoft.com> wrote in message
news:B924F619-4B1C-4657-B61B-41DA672541CE@.microsoft.com...
> I've been exploring the best practices tool and find most things great! I
have installed it on multiple machines and then changed the database that
each client logs into to be the same one so that we have one central
repository and it seems to be working well. I would like to see a way to
schedule a job that would run the scans at off hours since we are trying to
make it mandatory for our developers to run a clean scan before they move
out of our development environment. I was also surprised when i noticed
that there were no stored procedures in the slqbpa database, isn't that
going against best practices ;)
|||Hello Debi,
how did you manage this?
I tried to install BPA on different machines...
but the tool doesn't support the same database for the different
installations.
did you install BPA on different machines with different databases?
what did you do with these databases - drop them?
how did you change the database to connect to?
Thanks Thomas
"Debi" wrote:
> I've been exploring the best practices tool and find most things great! I have installed it on multiple machines and then changed the database that each client logs into to be the same one so that we have one central repository and it seems to be worki
ng well. I would like to see a way to schedule a job that would run the scans at off hours since we are trying to make it mandatory for our developers to run a clean scan before they move out of our development environment. I was also surprised when i n
oticed that there were no stored procedures in the slqbpa database, isn't that going against best practices ;)
|||Have a look at http://www.sqldbatips.com/showarticle.asp?ID=9
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Mueller-Lynch Thomas" <MuellerLynchThomas@.discussions.microsoft.com> wrote
in message news:1EBAEBEF-38D1-471A-B277-B685AE3EB4BE@.microsoft.com...[vbcol=seagreen]
> Hello Debi,
> how did you manage this?
> I tried to install BPA on different machines...
> but the tool doesn't support the same database for the different
> installations.
> did you install BPA on different machines with different databases?
> what did you do with these databases - drop them?
> how did you change the database to connect to?
> Thanks Thomas
> "Debi" wrote:
well. I would like to see a way to schedule a job that would run the scans at off hours since we are trying to make it mandatory for our developers to run a clean scan before they move out of our development environment. I was also surprised when i not
iced that there were no stored procedures in the slqbpa database, isn't that going against best practices ;)
Debi
In the released version there will be a command line version that will let
you use sql agent or some other scheduler to do what you want.
About stored procedures... not that strictly a best practice... depends on
your application or on what you're trying to do. The extensible architecture
of bpa called for some adhoc query building which may be better in the app
than doing dynamic sql inside stored procs. That said, I would like to see
some of the logic moved to stored procs, post v1. In the pre-7.0 days,
stored procs were way more a perf best practice.
- Christian
___________________________
Christian Kleinerman
Program Manager, SQL Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Debi" <anonymous@.discussions.microsoft.com> wrote in message
news:B924F619-4B1C-4657-B61B-41DA672541CE@.microsoft.com...
> I've been exploring the best practices tool and find most things great! I
have installed it on multiple machines and then changed the database that
each client logs into to be the same one so that we have one central
repository and it seems to be working well. I would like to see a way to
schedule a job that would run the scans at off hours since we are trying to
make it mandatory for our developers to run a clean scan before they move
out of our development environment. I was also surprised when i noticed
that there were no stored procedures in the slqbpa database, isn't that
going against best practices ;)
|||Hello Debi,
how did you manage this?
I tried to install BPA on different machines...
but the tool doesn't support the same database for the different
installations.
did you install BPA on different machines with different databases?
what did you do with these databases - drop them?
how did you change the database to connect to?
Thanks Thomas
"Debi" wrote:
> I've been exploring the best practices tool and find most things great! I have installed it on multiple machines and then changed the database that each client logs into to be the same one so that we have one central repository and it seems to be worki
ng well. I would like to see a way to schedule a job that would run the scans at off hours since we are trying to make it mandatory for our developers to run a clean scan before they move out of our development environment. I was also surprised when i n
oticed that there were no stored procedures in the slqbpa database, isn't that going against best practices ;)
|||Have a look at http://www.sqldbatips.com/showarticle.asp?ID=9
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Mueller-Lynch Thomas" <MuellerLynchThomas@.discussions.microsoft.com> wrote
in message news:1EBAEBEF-38D1-471A-B277-B685AE3EB4BE@.microsoft.com...[vbcol=seagreen]
> Hello Debi,
> how did you manage this?
> I tried to install BPA on different machines...
> but the tool doesn't support the same database for the different
> installations.
> did you install BPA on different machines with different databases?
> what did you do with these databases - drop them?
> how did you change the database to connect to?
> Thanks Thomas
> "Debi" wrote:
Bound SQL to IP address
Hi!
If there are a few NIC installed in server is it possible to make SQL Server
2000 listen only on specific IP address?
Regards
Silmar"Silmar" <silmar@.talex.pl> wrote in message
news:OuC0#kMCHHA.3448@.TK2MSFTNGP03.phx.gbl...
> Hi!
> If there are a few NIC installed in server is it possible to make SQL
> Server 2000 listen only on specific IP address?
>
No. Only SQL 2005 can do this.
David
If there are a few NIC installed in server is it possible to make SQL Server
2000 listen only on specific IP address?
Regards
Silmar"Silmar" <silmar@.talex.pl> wrote in message
news:OuC0#kMCHHA.3448@.TK2MSFTNGP03.phx.gbl...
> Hi!
> If there are a few NIC installed in server is it possible to make SQL
> Server 2000 listen only on specific IP address?
>
No. Only SQL 2005 can do this.
David
Bound SQL to IP address
Hi!
If there are a few NIC installed in server is it possible to make SQL Server
2000 listen only on specific IP address?
Regards
Silmar"Silmar" <silmar@.talex.pl> wrote in message
news:OuC0#kMCHHA.3448@.TK2MSFTNGP03.phx.gbl...
> Hi!
> If there are a few NIC installed in server is it possible to make SQL
> Server 2000 listen only on specific IP address?
>
No. Only SQL 2005 can do this.
David
If there are a few NIC installed in server is it possible to make SQL Server
2000 listen only on specific IP address?
Regards
Silmar"Silmar" <silmar@.talex.pl> wrote in message
news:OuC0#kMCHHA.3448@.TK2MSFTNGP03.phx.gbl...
> Hi!
> If there are a few NIC installed in server is it possible to make SQL
> Server 2000 listen only on specific IP address?
>
No. Only SQL 2005 can do this.
David
Bought and installed VS2005 professional - There is no Management studio got installed in
Hi Friends,
I have a question. At my home computer i downloaded and
installed VWD. As usual it also installed Sqlexpress as part of the
installation(i checked the option). Later on i downloaded Management
studio separately so i am fine with my home computer as every thing is free.
But at work we decided to develop application using VS 2005 and Sqlserver 2005. So we bought and installed VS2005 professional edition at work and it also installed Sqlexpress during the installation as a defualt desktop engine. I am fine with that too. But i am not
understing where do i get the Management studio? Is it some thing i
could get it off the web for free or what? I am not sure we would have an option while installing the VS 2005 professional that also does install management studio and we need to check that option. I am not sure if we could get the management studion off the web for free and and evelop applications.
Please advise.
Thanks
-L
Yes we can download the Management Studio Express for free from MS website. I did the same thing on my personal laptop. But can we develop applications using free downloaded Management Studio and deploy later on with the free stuff at work?
Or else like you have mentioned may be i want to get it off Sql server 2005.
May be you can help me figuring out where i can get it off
Its kind of confusing what to install of all the CDs we got when we bought the software.
Please bear with me the list of CDs we have is:
1).Microsoft Visual Studio 2005 Professional Edition (Disc1 & Disc 2)
2)Microsoft Visual Studio 2005 Professional Edition (SQL Server 2005 Developer Edition 32-bit Cd1 & CD2)
3).Microsoft SQL Server 2005 Developer Edition (32 bit) (Disc1 & Disc 2)
4).Microsoft Visual Studio 2005 Professional Edition (SQL Server 2005 Developer Edition IA 64-bit CD1 and CD2)
5).Microsoft Sql server 2005 Developer Edition for Itanium-based Systems (Disc 1 & Disc 2)
6).Microsoft Sql server 2005 Developer Edition (X64) (Disc 1 & Disc 2)
7).Microsoft Visual Studio 2005 Professional Edition (Sql server 2005 Developer Edition 64-bit CD1 & CD2)
My work machine runs on Windows XP Prof . Of all the above CDs I installed Visual Studio 2005 Professional alone. So i have VS 2005 installed and also SQL Express.
Like you said can use #2 set of CDs to get Management Studio or #3 set of CDs(i have windows XP professional installed on my work machine)?
We have already ordered another development box from Dell and we are going to have Windows 2003 server on that. Correct me if i am wrong, #4,5, and 6 set of CDs are designed for 64-bit Windows 2003 server.
what is IA in #4 set of CDs and Itanium-based system in #5 respectively?
Am i getting you confusing with lot of stupid questions here :)?
I have lot of questions with the new stuff.
Thanks
-L
|||Wish I could help you. Unfortunately, I don't have a set of retail disks. My home machine has .ISO's I downloaded from MSDN (I have a personal MSDN Subscription), and at work, they install whatever I tell them to, but they lock up the disks and licenses.
Friday, February 10, 2012
Both Versions of .NET & Reporting Services
I have a windows 2000 SP4 server on which I have installed Reporting Services
but keep getting a "Access Denied 401" error.
Could this be because I am running both versions of .NET
.net 1.0 SP1
.net 1.1
?
--
EdgarNot as long as ASP.NET is using the latest version (1.1). You might try
aspnet_regiis -i in the 1.1 directory.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"mresanchez" <mresanchez@.donot-spam.com> wrote in message
news:769E4D70-3104-4D12-AE5C-690664353C7C@.microsoft.com...
>I have a windows 2000 SP4 server on which I have installed Reporting
>Services
> but keep getting a "Access Denied 401" error.
> Could this be because I am running both versions of .NET
> .net 1.0 SP1
> .net 1.1
> ?
> --
> Edgar|||Brian,
When I installed RS, the setup automatically put it in the "Default" Web
Site. I have since moved it to a different Web Site & Copied all the
permissions, etc. Does RS have to be on its on dedicated Web Site (Ip
Address) or can it simply be made part of a different web site as a new
Virtual Directory (mysite.com/Reports)?
"Brian Welcker [MS]" wrote:
> Not as long as ASP.NET is using the latest version (1.1). You might try
> aspnet_regiis -i in the 1.1 directory.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "mresanchez" <mresanchez@.donot-spam.com> wrote in message
> news:769E4D70-3104-4D12-AE5C-690664353C7C@.microsoft.com...
> >I have a windows 2000 SP4 server on which I have installed Reporting
> >Services
> > but keep getting a "Access Denied 401" error.
> >
> > Could this be because I am running both versions of .NET
> > .net 1.0 SP1
> > .net 1.1
> > ?
> > --
> > Edgar
>
>|||It can be in any web site. However, unless you are running Windows Server
2003, all application within a web site share the same version of the
frameworks (since there is only one worker process). On Windows Server 2003,
you can create multiple application pools with different versions of the
Frameworks and then assign applications to them.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"mresanchez" <mresanchez@.donot-spam.com> wrote in message
news:6620EDB4-04EB-4A1E-83DD-28153B2F02DB@.microsoft.com...
> Brian,
> When I installed RS, the setup automatically put it in the "Default" Web
> Site. I have since moved it to a different Web Site & Copied all the
> permissions, etc. Does RS have to be on its on dedicated Web Site (Ip
> Address) or can it simply be made part of a different web site as a new
> Virtual Directory (mysite.com/Reports)?
> "Brian Welcker [MS]" wrote:
>> Not as long as ASP.NET is using the latest version (1.1). You might try
>> aspnet_regiis -i in the 1.1 directory.
>> --
>> Brian Welcker
>> Group Program Manager
>> Microsoft SQL Server
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "mresanchez" <mresanchez@.donot-spam.com> wrote in message
>> news:769E4D70-3104-4D12-AE5C-690664353C7C@.microsoft.com...
>> >I have a windows 2000 SP4 server on which I have installed Reporting
>> >Services
>> > but keep getting a "Access Denied 401" error.
>> >
>> > Could this be because I am running both versions of .NET
>> > .net 1.0 SP1
>> > .net 1.1
>> > ?
>> > --
>> > Edgar
>>
but keep getting a "Access Denied 401" error.
Could this be because I am running both versions of .NET
.net 1.0 SP1
.net 1.1
?
--
EdgarNot as long as ASP.NET is using the latest version (1.1). You might try
aspnet_regiis -i in the 1.1 directory.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"mresanchez" <mresanchez@.donot-spam.com> wrote in message
news:769E4D70-3104-4D12-AE5C-690664353C7C@.microsoft.com...
>I have a windows 2000 SP4 server on which I have installed Reporting
>Services
> but keep getting a "Access Denied 401" error.
> Could this be because I am running both versions of .NET
> .net 1.0 SP1
> .net 1.1
> ?
> --
> Edgar|||Brian,
When I installed RS, the setup automatically put it in the "Default" Web
Site. I have since moved it to a different Web Site & Copied all the
permissions, etc. Does RS have to be on its on dedicated Web Site (Ip
Address) or can it simply be made part of a different web site as a new
Virtual Directory (mysite.com/Reports)?
"Brian Welcker [MS]" wrote:
> Not as long as ASP.NET is using the latest version (1.1). You might try
> aspnet_regiis -i in the 1.1 directory.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "mresanchez" <mresanchez@.donot-spam.com> wrote in message
> news:769E4D70-3104-4D12-AE5C-690664353C7C@.microsoft.com...
> >I have a windows 2000 SP4 server on which I have installed Reporting
> >Services
> > but keep getting a "Access Denied 401" error.
> >
> > Could this be because I am running both versions of .NET
> > .net 1.0 SP1
> > .net 1.1
> > ?
> > --
> > Edgar
>
>|||It can be in any web site. However, unless you are running Windows Server
2003, all application within a web site share the same version of the
frameworks (since there is only one worker process). On Windows Server 2003,
you can create multiple application pools with different versions of the
Frameworks and then assign applications to them.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
"mresanchez" <mresanchez@.donot-spam.com> wrote in message
news:6620EDB4-04EB-4A1E-83DD-28153B2F02DB@.microsoft.com...
> Brian,
> When I installed RS, the setup automatically put it in the "Default" Web
> Site. I have since moved it to a different Web Site & Copied all the
> permissions, etc. Does RS have to be on its on dedicated Web Site (Ip
> Address) or can it simply be made part of a different web site as a new
> Virtual Directory (mysite.com/Reports)?
> "Brian Welcker [MS]" wrote:
>> Not as long as ASP.NET is using the latest version (1.1). You might try
>> aspnet_regiis -i in the 1.1 directory.
>> --
>> Brian Welcker
>> Group Program Manager
>> Microsoft SQL Server
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "mresanchez" <mresanchez@.donot-spam.com> wrote in message
>> news:769E4D70-3104-4D12-AE5C-690664353C7C@.microsoft.com...
>> >I have a windows 2000 SP4 server on which I have installed Reporting
>> >Services
>> > but keep getting a "Access Denied 401" error.
>> >
>> > Could this be because I am running both versions of .NET
>> > .net 1.0 SP1
>> > .net 1.1
>> > ?
>> > --
>> > Edgar
>>
BossEveryWare and Analysis Services
After I installed SQL Server Analysis services, I have a .dsv extension in my registry. My anti-spyware program keeps flagging it as the BossEveryWare spyware program because BEW uses .dsv as one of it's main logging file extensions. I have checked for other traces of BEW and cannot find any. I do not have any wierd tcp packets going out either. Am I safe in assuming that .dsv is also used by Analysis services in a safe manner?
Thanks
http://www.nateandrews.com
When I followed the tutorial for analysis services I recall saving Data Source View files. DSV. From that I can imagine you are not having a spyware problem...
You should be safe with your assumption.
Subscribe to:
Posts (Atom)