 |
|
|
|
Next: Database Design
|
| Author |
Message |
External
Since: Dec 30, 2008
Posts: 3
|
(Msg. 1) Posted: Tue Dec 30, 2008 9:21 am
Post subject: SQLServer-2005 connectivity to SQLServer-2000...
Archived from groups: microsoft>public>sqlserver>setup (more info?)
|
|
|
I have two installations of SQLServer (different versions) across my VPN.
I can get SQLServer connectivity across my VPN (via NamedPipes) from
SQLServer-2005 to SQLServer-2000, but not reverse (SQLServer-2000 to
SQLServer-2005). Is this an issue that anyone else has encountered?
Any assistance is appreciated.
thank you,
Blaise. |
|
| Back to top |
|
 | |
External
Since: Feb 06, 2008
Posts: 47
|
(Msg. 2) Posted: Wed Dec 31, 2008 8:39 am
Post subject: Re: SQLServer-2005 connectivity to SQLServer-2000... [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
SQL Server 2005 does not allow remote connectivity by default. If you are
unfamiliar with enabling a protocol on SQL Server 2005, review the short
tutorial in Books Online.
http://msdn.microsoft.com/en-us/library/ms345318(SQL.90).aspx
--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.
"Blaise" wrote in message
>I have two installations of SQLServer (different versions) across my VPN.
>
> I can get SQLServer connectivity across my VPN (via NamedPipes) from
> SQLServer-2005 to SQLServer-2000, but not reverse (SQLServer-2000 to
> SQLServer-2005). Is this an issue that anyone else has encountered?
>
> Any assistance is appreciated.
>
> thank you,
>
> Blaise.
>
>
> |
|
| Back to top |
|
| |
External
Since: Jan 11, 2008
Posts: 267
|
(Msg. 3) Posted: Fri Jan 02, 2009 6:25 pm
Post subject: Re: SQLServer-2005 connectivity to SQLServer-2000... [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
You are not correct Rick. For example SQL Server 2005 Enterprise Edition
does allow remote connections by default. If I remember correctly, Developer
Edition also allows it. Express and Standard Edition does not. For instance
if you install a SQL Server 2005 Enterprise Edition, network users can
connect to it using it's instance name and TCP/IP protocol by default.
Remote connection setting (TCP/IP be enabled\disabled) depends on the
edition of SQL Server.
--
Ekrem Önsoy
"Rick Byham, (MSFT)" wrote in message
> SQL Server 2005 does not allow remote connectivity by default. If you are
> unfamiliar with enabling a protocol on SQL Server 2005, review the short
> tutorial in Books Online.
> http://msdn.microsoft.com/en-us/library/ms345318(SQL.90).aspx
> --
> Rick Byham (MSFT), SQL Server Books Online
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Blaise" wrote in message
>
>>I have two installations of SQLServer (different versions) across my VPN.
>>
>> I can get SQLServer connectivity across my VPN (via NamedPipes) from
>> SQLServer-2005 to SQLServer-2000, but not reverse (SQLServer-2000 to
>> SQLServer-2005). Is this an issue that anyone else has encountered?
>>
>> Any assistance is appreciated.
>>
>> thank you,
>>
>> Blaise.
>>
>>
>>
> >> Stay informed about: SQLServer-2005 connectivity to SQLServer-2000... |
|
| Back to top |
|
| |
External
Since: Feb 06, 2008
Posts: 47
|
(Msg. 4) Posted: Fri Jan 02, 2009 6:25 pm
Post subject: Re: SQLServer-2005 connectivity to SQLServer-2000... [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Of course you are correct. I was being too brief. Sorry if I caused any
confusion.
--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ekrem Önsoy" wrote in message
> You are not correct Rick. For example SQL Server 2005 Enterprise Edition
> does allow remote connections by default. If I remember correctly,
> Developer Edition also allows it. Express and Standard Edition does not.
> For instance if you install a SQL Server 2005 Enterprise Edition, network
> users can connect to it using it's instance name and TCP/IP protocol by
> default.
>
> Remote connection setting (TCP/IP be enabled\disabled) depends on the
> edition of SQL Server.
>
> --
> Ekrem Önsoy
>
>
>
> "Rick Byham, (MSFT)" wrote in message
>
>> SQL Server 2005 does not allow remote connectivity by default. If you are
>> unfamiliar with enabling a protocol on SQL Server 2005, review the short
>> tutorial in Books Online.
>> http://msdn.microsoft.com/en-us/library/ms345318(SQL.90).aspx
>> --
>> Rick Byham (MSFT), SQL Server Books Online
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Blaise" wrote in message
>>
>>>I have two installations of SQLServer (different versions) across my VPN.
>>>
>>> I can get SQLServer connectivity across my VPN (via NamedPipes) from
>>> SQLServer-2005 to SQLServer-2000, but not reverse (SQLServer-2000 to
>>> SQLServer-2005). Is this an issue that anyone else has encountered?
>>>
>>> Any assistance is appreciated.
>>>
>>> thank you,
>>>
>>> Blaise.
>>>
>>>
>>>
>>
> >> Stay informed about: SQLServer-2005 connectivity to SQLServer-2000... |
|
| Back to top |
|
| |
External
Since: Jan 11, 2008
Posts: 267
|
(Msg. 5) Posted: Sat Jan 03, 2009 4:20 pm
Post subject: Re: SQLServer-2005 connectivity to SQLServer-2000... [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
No confusion for me, I just wanted to make it clear for the OP.
--
Ekrem Önsoy
"Rick Byham, (MSFT)" wrote in message
> Of course you are correct. I was being too brief. Sorry if I caused any
> confusion.
> --
> Rick Byham (MSFT), SQL Server Books Online
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> "Ekrem Önsoy" wrote in message
>
>> You are not correct Rick. For example SQL Server 2005 Enterprise Edition
>> does allow remote connections by default. If I remember correctly,
>> Developer Edition also allows it. Express and Standard Edition does not.
>> For instance if you install a SQL Server 2005 Enterprise Edition, network
>> users can connect to it using it's instance name and TCP/IP protocol by
>> default.
>>
>> Remote connection setting (TCP/IP be enabled\disabled) depends on the
>> edition of SQL Server.
>>
>> --
>> Ekrem Önsoy
>>
>>
>>
>> "Rick Byham, (MSFT)" wrote in
>> message
>>> SQL Server 2005 does not allow remote connectivity by default. If you
>>> are unfamiliar with enabling a protocol on SQL Server 2005, review the
>>> short tutorial in Books Online.
>>> http://msdn.microsoft.com/en-us/library/ms345318(SQL.90).aspx
>>> --
>>> Rick Byham (MSFT), SQL Server Books Online
>>> This posting is provided "AS IS" with no warranties, and confers no
>>> rights.
>>>
>>> "Blaise" wrote in message
>>>
>>>>I have two installations of SQLServer (different versions) across my
>>>>VPN.
>>>>
>>>> I can get SQLServer connectivity across my VPN (via NamedPipes) from
>>>> SQLServer-2005 to SQLServer-2000, but not reverse (SQLServer-2000 to
>>>> SQLServer-2005). Is this an issue that anyone else has encountered?
>>>>
>>>> Any assistance is appreciated.
>>>>
>>>> thank you,
>>>>
>>>> Blaise.
>>>>
>>>>
>>>>
>>>
>>
> >> Stay informed about: SQLServer-2005 connectivity to SQLServer-2000... |
|
| Back to top |
|
| |
| Related Topics: | SQLServer 2005 and raw devices on NetApp Filers - Hello all, does anyone know if it's possibile to use raw devices from a NetApp Filers with SQLServer 2005 (maybe in active/passive cluster configuration)? Thanks Stefano
fail to install SQLserver 2000 Persional Edition - When I install it. It prompt The instr at ")x42b980fd reference memory at "0x00000000" the memory cannot be read. Anyone can help it. Thank for your support Best Regards
Error Installing SQLServer (MSDN version) - I'm attempting to install SQL Server (2005 Enterprise) on a Dell XPS720 Quad Core, 4GB RAM box with 32-bit Windows Server 2003. After the initial splash screen displays, when I click on any option group in the left-hand pane of the window, I get an..
upgrate from 2000 to 2005 - I have some databases on sql 2000 Developer Ed SP4 version 8.00.2039 and it work with reporting services Developer Ed version 8.0.1038.00. I need upgrade it to sql2005 and reporting services 2005 too SP2. But I want to do upgrade without backup/restor...
Upgrading from 2000 to 2005 - For most part, this upgrade was successfull, except for Reporting Services. The log stated that since I have the db files required by reporting services left over from 2000, I can't install reporting services for 2005. a) How to resolve this? b) Can ... |
|
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum
|
|
|
|
|
|
|
FAQ
Search
Profile
Private Messages
Log in
