I'm unable to install SQL SERVER 2005 develop ed. and VISUAL STUDIO 2005

I'm unable to install SQL SERVER 2005 develop ed. and VISUAL STUDIO 2005 in
the same computer.
I have tried to install several times from different ways and all was with
error.
I understand that I have to uninstall all previous versions os SQL and VS. I
done it.
I understand that first I have to install is SQL Server and after VS
selecting "custom" installation choice and deselecting the last entry in the
list: "Express Edition of SQL Server"
Doing so, I have installed SQL SERVER sucessfully. But, when tried to
install VS the Window's installation disappear without tellling nothing. No
error, no message. Don't arrive to the installation options !
Please, someone could give some help ?
Thanks!
hi,
3Dfelix wrote:
> I'm unable to install SQL SERVER 2005 develop ed. and VISUAL STUDIO
> 2005 in the same computer.
> I have tried to install several times from different ways and all was
> with error.
> I understand that I have to uninstall all previous versions os SQL
> and VS. I done it.
> I understand that first I have to install is SQL Server and after VS
> selecting "custom" installation choice and deselecting the last entry
> in the list: "Express Edition of SQL Server"
> Doing so, I have installed SQL SERVER sucessfully. But, when tried to
> install VS the Window's installation disappear without tellling
> nothing. No error, no message. Don't arrive to the installation
> options !
personally I did the opposit way... first VS2005 and then SQL Server 2005..
with no problem at all...
ok, this has been done on a "clean" box, that's to say on a box without
"beta" of "2005" tools (SQL or VS) installed...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.bizhttp://italy.mvps.org
DbaMgr2k ver 0.20.0 - DbaMgr ver 0.64.0 and further SQL Tools
-- remove DMO to reply

im going crazy

I just got bought a used computer, and Im trying to change the server name, I've changed the computer name and restarted the computer, I've also used query analyser and changed the server name, but when I try run an c# appication that connects to a sql database I get a server does not exist/access denied error message.

when I go to enterprise manager and server service manager the server name still comes up as PICARD\HOMESQL

obvuiusly I cant use a "\" in the connection string of my windows application.

does anybody know how I can change the server name to PETER.

thanks in advance

What is your actual connection string ? Make sure that you either have to @.Qoute your string or escape your string to allow the backslash. If the names server is on another port than the default one and SQL Server is not started you have to name the port after the name Servername\Instance,Port

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Thanks for your reply. This is my connection string:

namespace BankAccounts

{

[Transaction(TransactionOption.Required), ObjectPooling(MinPoolSize =1,

MaxPoolSize =5),

JustInTimeActivation(true), SecurityRole("Authorized Users", false),

ConstructionEnabled(Default =

"server=MARCUS; database=Northwind; integrated security=sspi;")]

in enterprise manager the server name is MARCUS\HOMESQL

but using this server name gives the same error.

|||Hi,

try using

"server=MARCUS\\HomeSQL; database=Northwind; integrated security=sspi;")] OR
@."server=MARCUS\\HomeSQL;; database=Northwind; integrated security=sspi;")]

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Thank you very much. My application work fine now. I see what the problem with my connection string was now.

again thank you very much.

learn something new everyday.

|||

BTW,

when I use server=local host as part of my connection string, why didnt it work?

|||OK, I don′t know how aware you are of the concept, so heres the concept in a short abstract:

The name SQL Server is sort of misleading, because its a Server service rather than a "server". Every SQL "Server" is instance, a default one or a named instance, which is, if you use TCP/IP bound to a port. THe keyword "Server" or "Data Source" points to a Service or an instance name, not the physical server name. For default instance it is the server name, for named instance the servername + the \Instancename. If you don′t have SQL Browser started, you have to specify the port for the connection. If SQL Browser is started it can redirect the request of the client to the appropiate port where the service is bound to.

Hope I made that a bit clearer.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de|||

airwalker2000 wrote:

BTW,

when I use server=local host as part of my connection string, why didnt it work?

should be (local) or (local)\instancename or (.) or (.)\instancename

or mypcname or mypcname\instancename

localhost is an IIS reserve word

(local) or (.) is for Sql server

|||Thanks joeydj....that really helped, much appreciated

I'll be away...

I will be out of the country (and without cell phone, pager, and computer
access) until February 3rd, but that day is Super Bowl Sunday, so make it
February 4th.
I apologize in advance if I abandon any ongoing threads, or if you expect an
answer from me and don't get one. I will have access for another day or so.
I doubt I'll be missed all that much, but I just wanted to have a disclaimer
here just in case.So long as you are at the bar in April :)
--
Tony Rogerson, SQL Server MVP
http://sqlblogcasts.com/blogs/tonyrogerson
[Ramblings from the field from a SQL consultant]
http://sqlserverfaq.com
[UK SQL User Community]
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:eCDSNaGXIHA.4712@.TK2MSFTNGP04.phx.gbl...
>I will be out of the country (and without cell phone, pager, and computer
>access) until February 3rd, but that day is Super Bowl Sunday, so make it
>February 4th.
> I apologize in advance if I abandon any ongoing threads, or if you expect
> an answer from me and don't get one. I will have access for another day
> or so.
> I doubt I'll be missed all that much, but I just wanted to have a
> disclaimer here just in case.
>|||> So long as you are at the bar in April :)
Wouldn't miss it!|||Where are you at Aaron ?
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:%23X5tKMHXIHA.4196@.TK2MSFTNGP04.phx.gbl...
>> So long as you are at the bar in April :)
> Wouldn't miss it!
>|||> Where are you at Aaron ?
I work out of Boston, MA.
A|||Cool.. Thanks..
I guess nows my chance to annoy everyone else until you get back. Kidding..
I need to get into trying stuff myself or googling for answers before
posting.
Hope to improve over time.
Thanks for all your help.
Enjoy your time off.
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:e3otpZKXIHA.5340@.TK2MSFTNGP06.phx.gbl...
>> Where are you at Aaron ?
> I work out of Boston, MA.
> A
>|||On Jan 21, 3:14 pm, "Aaron Bertrand [SQL Server MVP]"
<ten...@.dnartreb.noraa> wrote:
> > So long as you are at the bar in April :)
> Wouldn't miss it!
likewise|||"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:e3otpZKXIHA.5340@.TK2MSFTNGP06.phx.gbl...
>> Where are you at Aaron ?
> I work out of Boston, MA.
>
Bastan? Hop in da cah, head down to da bah, hang a left at da rotary...

IIS security problem

Hi,
I have IIS5.0 running on w2k (SP3) for SQL reporting service(SP1). IIS has all the patches that I can find. While IIS running, this computer has been hijacked or turn to proxy server to deliver spam mails. How can I provent it (no smpt service running.)I am not sure I understand the issue you're facing, can you explain some
more?
--
Tudor Trufinescu
Dev Lead
Sql Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"csoon" <csoon@.discussions.microsoft.com> wrote in message
news:C14F67AF-AA2D-4529-BF58-E170171B0410@.microsoft.com...
> Hi,
> I have IIS5.0 running on w2k (SP3) for SQL reporting service(SP1). IIS
has all the patches that I can find. While IIS running, this computer has
been hijacked or turn to proxy server to deliver spam mails. How can I
provent it (no smpt service running.)|||Note that you do not need to have either an email client nor an email server
running. There would be no way for your server to be hijacked if you do not
have these installed. Yes, you can use either but you do not need to. I am
configured where RS sends the email to an SMTP server which resides
elsewhere.
Bruce L-C
"csoon" <csoon@.discussions.microsoft.com> wrote in message
news:CFC072A9-A3E9-46A2-BDAF-ECD7BE320BB9@.microsoft.com...
> I keep getting email indicate that my computer was hijack and used as
proxy server to deliver hugh emails while IIS5.0 running. It is very
difficult to get budget to try sql reporting service specially it is not
secure. First I did implement sending email in sql reporting service by
changing in configuration file (drop off email files in a folder to smtp to
pick them up). Once I had this problem then I turned off smtp but I still
got emails indicated that my computer was hijacked. I installed lock down
IIS and all the patch for IIS5.0. I would like to try RS but if I still
cause problem to others, I might not be able to test or implement this
software. If you need more info. please let me know.
> "Tudor Trufinescu (MSFT)" wrote:
> > I am not sure I understand the issue you're facing, can you explain some
> > more?
> >
> > --
> > Tudor Trufinescu
> > Dev Lead
> > Sql Server Reporting Services
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "csoon" <csoon@.discussions.microsoft.com> wrote in message
> > news:C14F67AF-AA2D-4529-BF58-E170171B0410@.microsoft.com...
> > > Hi,
> > > I have IIS5.0 running on w2k (SP3) for SQL reporting service(SP1).
IIS
> > has all the patches that I can find. While IIS running, this computer
has
> > been hijacked or turn to proxy server to deliver spam mails. How can I
> > provent it (no smpt service running.)
> >
> >
> >|||Thanks. Unfortunately, this is a test on my computer, I have to have mail client on this computer.
"Bruce Loehle-Conger" wrote:
> Note that you do not need to have either an email client nor an email server
> running. There would be no way for your server to be hijacked if you do not
> have these installed. Yes, you can use either but you do not need to. I am
> configured where RS sends the email to an SMTP server which resides
> elsewhere.
> Bruce L-C
> "csoon" <csoon@.discussions.microsoft.com> wrote in message
> news:CFC072A9-A3E9-46A2-BDAF-ECD7BE320BB9@.microsoft.com...
> > I keep getting email indicate that my computer was hijack and used as
> proxy server to deliver hugh emails while IIS5.0 running. It is very
> difficult to get budget to try sql reporting service specially it is not
> secure. First I did implement sending email in sql reporting service by
> changing in configuration file (drop off email files in a folder to smtp to
> pick them up). Once I had this problem then I turned off smtp but I still
> got emails indicated that my computer was hijacked. I installed lock down
> IIS and all the patch for IIS5.0. I would like to try RS but if I still
> cause problem to others, I might not be able to test or implement this
> software. If you need more info. please let me know.
> >
> > "Tudor Trufinescu (MSFT)" wrote:
> >
> > > I am not sure I understand the issue you're facing, can you explain some
> > > more?
> > >
> > > --
> > > Tudor Trufinescu
> > > Dev Lead
> > > Sql Server Reporting Services
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > >
> > >
> > > "csoon" <csoon@.discussions.microsoft.com> wrote in message
> > > news:C14F67AF-AA2D-4529-BF58-E170171B0410@.microsoft.com...
> > > > Hi,
> > > > I have IIS5.0 running on w2k (SP3) for SQL reporting service(SP1).
> IIS
> > > has all the patches that I can find. While IIS running, this computer
> has
> > > been hijacked or turn to proxy server to deliver spam mails. How can I
> > > provent it (no smpt service running.)
> > >
> > >
> > >
>
>