Showing posts with label win2003. Show all posts
Showing posts with label win2003. Show all posts

Wednesday, March 28, 2012

How to connect to the June Katmai CTP?

Hi all,

I'm new to the Katmai SQL Server. I have just installed the June CTP x64 developer edition on a Win2003 Server AMD x64 bit. I installed everything. The install went fine.

My question:

How do I connect to the Katmai? There where no Management Studio in the install package.

The SQL Server 2005 Management Studio will not connect. It says that it can only connect to SQL 2000 or SQL 2005.

Best regards,

Lars-Inge

(Lars-Inge Tønnessen@.discussions.microsoft.com) writes: > I'm new to the Katmai SQL Server. I have just installed the June CTP x64 > developer edition on a Win2003 Server AMD x64 bit. I installed > everything. The install went fine. > > > > My question: > > How do I connect to the Katmai? There where no Management Studio in the > install package. There was in mine. Hm, I installed 32-bit. Could it be that tools are in the 32-bit distribution? (Tools are 32-bit anyway.) Also, look for a setup in the Tools directory if there is one. > The SQL Server 2005 Management Studio will not connect. It says that it > can only connect to SQL 2000 or SQL 2005. SQLCMD and OSQL works. And Query Analyzer from SQL 2000, if you have it around. -- Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx|||I also tried to install SQL 2008 on VPC for Orcas. I see only configuration tools.

Monday, March 26, 2012

How to connect to a dedicated m/c

Hi,
Recently i installed SQL server 2000(EE)on my remote dedicated server( win
2003). I haven't installed ant Service packs. Now the problem is i am not
able to connect to the SQL server either thru Query Analyzer or thru the
application. I have disabled the firewall, still no use. Can anyone help
me.But thru remote desktop, i was able to connect to the server m/c by
putting the ip address .
regards lara
First thing to do is install SP3. SQL2000 RTM isn't supported on
Windows 2003.
David Portas
SQL Server MVP
|||Hi,
I've installed SP3
This is what i get when i run SELECT @.@.Version
"
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
"
I've disabled the firewall, enaled TCP/IP, set default port to 1433. and no
use till now
The same error is diplaying again and again 'Server Msg 17, Level 16, State
1
MS [ODBC Sql Server][DBNETLIB]SQL Server does not exist or access denied'
regards lara
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:1119436842.190857.7930@.o13g2000cwo.googlegrou ps.com...
> First thing to do is install SP3. SQL2000 RTM isn't supported on
> Windows 2003.
> --
> David Portas
> SQL Server MVP
> --
>
|||Hi,
I've installed SP3
This is what i get when i run SELECT @.@.Version
"
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
"
I've disabled the firewall, enaled TCP/IP, set default port to 1433. and no
use till now
The same error is diplaying again and again 'Server Msg 17, Level 16, State
1
MS [ODBC Sql Server][DBNETLIB]SQL Server does not exist or access denied'
regards lara

How to connect to a dedicated m/c

Hi,
Recently i installed SQL server 2000(EE)on my remote dedicated server( win
2003). I haven't installed ant Service packs. Now the problem is i am not
able to connect to the SQL server either thru Query Analyzer or thru the
application. I have disabled the firewall, still no use. Can anyone help
me.But thru remote desktop, i was able to connect to the server m/c by
putting the ip address .
regards laraFirst thing to do is install SP3. SQL2000 RTM isn't supported on
Windows 2003.
David Portas
SQL Server MVP
--|||Hi,
I've installed SP3
This is what i get when i run SELECT @.@.Version
"
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
"
I've disabled the firewall, enaled TCP/IP, set default port to 1433. and no
use till now
The same error is diplaying again and again 'Server Msg 17, Level 16, State
1
MS [ODBC Sql Server][DBNETLIB]SQL Server does not exist or access de
nied'
regards lara
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:1119436842.190857.7930@.o13g2000cwo.googlegroups.com...
> First thing to do is install SP3. SQL2000 RTM isn't supported on
> Windows 2003.
> --
> David Portas
> SQL Server MVP
> --
>|||Hi,
I've installed SP3
This is what i get when i run SELECT @.@.Version
"
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
"
I've disabled the firewall, enaled TCP/IP, set default port to 1433. and no
use till now
The same error is diplaying again and again 'Server Msg 17, Level 16, State
1
MS [ODBC Sql Server][DBNETLIB]SQL Server does not exist or access de
nied'
regards lara

Monday, March 19, 2012

how to configure RS2000 to use .Net framework 1.1 from 2.0?

Good morning,
This is a continuation post about a problem I am having where I can't open
Report Manager. Here is my scenario - win2003 server running Sql Server 2000
Sp4, RS2000. We were on .Net framework 1.1 but upgraded this last year to
.Net framework 2.0 so we could use Visual Studio 2005. We still have Visual
Studio 2003 so that we can use RS2000 designer. I can deploy reports OK, but
I can't open Report manager - keep gettting varoius HTTP errors, 401, 403. I
got one error that said the Webpage (for Report Manager) was looking for .Net
Framework 1.1 and couldn't find it).
I looked at IIS at the Reports Virtual Dir and the VirtualDir
tabl/Configuration dialog - the application extensions window has all the
extensions looing at .Net Framwork 1.1 which I presume is why I can still
deploy reports. But on the ReportServer virtual dir in the configuration
dialog - the application extensions window is empty, but the Wildcard
Application Extension window has this path:
C:\Windows\Microsoft.Net\Framework\v1.1.4322\aspnet_isapi.dll
In the Reports virtual dir/configuration/application extensions window, the
.aspx extension points to the same path as above. Do I need to add an
extension as above to the the application Extensions window in the
configuration dialog for the ReportServer virtual dir so that Report Manger
page can run correctly?
Thanks,
RichHere is something interesting:
On the server I typed http://localhost/reportserver
and I got a directory listing of all the dirs on the report server and was
able to invoke reports directly from here. But when I type
http://localhost/reports
I get the message that the website declined to show this webpage - http
error 403 - IE can connect to the website but doesn't have permission to view
the page. Does anyone know what the difference is between the ReportServer
virtual dir and the Reports Virtual dir?
"Rich" wrote:
> Good morning,
> This is a continuation post about a problem I am having where I can't open
> Report Manager. Here is my scenario - win2003 server running Sql Server 2000
> Sp4, RS2000. We were on .Net framework 1.1 but upgraded this last year to
> .Net framework 2.0 so we could use Visual Studio 2005. We still have Visual
> Studio 2003 so that we can use RS2000 designer. I can deploy reports OK, but
> I can't open Report manager - keep gettting varoius HTTP errors, 401, 403. I
> got one error that said the Webpage (for Report Manager) was looking for .Net
> Framework 1.1 and couldn't find it).
> I looked at IIS at the Reports Virtual Dir and the VirtualDir
> tabl/Configuration dialog - the application extensions window has all the
> extensions looing at .Net Framwork 1.1 which I presume is why I can still
> deploy reports. But on the ReportServer virtual dir in the configuration
> dialog - the application extensions window is empty, but the Wildcard
> Application Extension window has this path:
> C:\Windows\Microsoft.Net\Framework\v1.1.4322\aspnet_isapi.dll
> In the Reports virtual dir/configuration/application extensions window, the
> .aspx extension points to the same path as above. Do I need to add an
> extension as above to the the application Extensions window in the
> configuration dialog for the ReportServer virtual dir so that Report Manger
> page can run correctly?
> Thanks,
> Rich
>|||As I mentioned in one of my last postings to you, I thought it was weird
that you could deploy. My thought being that reportserver website might be
at 1.1 and reports being at 2.0 framework.
Report Manager (reports website) is a portal to Reporting Services. It is
just an asp.net application that integrates with ReportServer website/app.
Some people do their own front ends and do not even use Report Manager. In
RS 2000 Report Manager integrates using URL integration with ReportServer.
In RS 2005 it uses webservices to integrate.
On your server open up IIS Manager. Click on each website, right mouse
click, properties, ASP.Net tab. See if 1.1 or 2.0 and make sure both Reports
and ReportServer are 1.1
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:177B4114-7F1A-459A-ACEE-8BF497DE2BD5@.microsoft.com...
> Here is something interesting:
> On the server I typed http://localhost/reportserver
> and I got a directory listing of all the dirs on the report server and was
> able to invoke reports directly from here. But when I type
> http://localhost/reports
> I get the message that the website declined to show this webpage - http
> error 403 - IE can connect to the website but doesn't have permission to
> view
> the page. Does anyone know what the difference is between the
> ReportServer
> virtual dir and the Reports Virtual dir?
> "Rich" wrote:
>> Good morning,
>> This is a continuation post about a problem I am having where I can't
>> open
>> Report Manager. Here is my scenario - win2003 server running Sql Server
>> 2000
>> Sp4, RS2000. We were on .Net framework 1.1 but upgraded this last year
>> to
>> .Net framework 2.0 so we could use Visual Studio 2005. We still have
>> Visual
>> Studio 2003 so that we can use RS2000 designer. I can deploy reports OK,
>> but
>> I can't open Report manager - keep gettting varoius HTTP errors, 401,
>> 403. I
>> got one error that said the Webpage (for Report Manager) was looking for
>> .Net
>> Framework 1.1 and couldn't find it).
>> I looked at IIS at the Reports Virtual Dir and the VirtualDir
>> tabl/Configuration dialog - the application extensions window has all the
>> extensions looing at .Net Framwork 1.1 which I presume is why I can still
>> deploy reports. But on the ReportServer virtual dir in the configuration
>> dialog - the application extensions window is empty, but the Wildcard
>> Application Extension window has this path:
>> C:\Windows\Microsoft.Net\Framework\v1.1.4322\aspnet_isapi.dll
>> In the Reports virtual dir/configuration/application extensions window,
>> the
>> .aspx extension points to the same path as above. Do I need to add an
>> extension as above to the the application Extensions window in the
>> configuration dialog for the ReportServer virtual dir so that Report
>> Manger
>> page can run correctly?
>> Thanks,
>> Rich|||Hi Bruce,
Thank you again for getting back to me on this (and I appologize in advance
for being a bonehead, but unfortunately I am one - right now). When I open
up IIS Manager I go to Websites/Default Website/Reports. I right click on
Reports/select properties. In this dialog I have 5 tabs - Virtual Directory,
Documents, Directory Security, HTTP Headers, Custom Errors. I clicked around
looking for a tab/button for ASP.Net, but did not locate anything.
Quick note: from my workstation if I type http://myserver/reportserver --
I can get a directory listing of all the dirs on the report server, I can
even run reports directly from that page. But if I type
http://myserver/Reports -- now I get a message that content listing is not
permitted from this site. It must be a configuration thing. What I lack in
braincells I compenste for with perseverence. What to configure?
Thank you for your patience and helping me out.
Rich
"Bruce L-C [MVP]" wrote:
> As I mentioned in one of my last postings to you, I thought it was weird
> that you could deploy. My thought being that reportserver website might be
> at 1.1 and reports being at 2.0 framework.
> Report Manager (reports website) is a portal to Reporting Services. It is
> just an asp.net application that integrates with ReportServer website/app.
> Some people do their own front ends and do not even use Report Manager. In
> RS 2000 Report Manager integrates using URL integration with ReportServer.
> In RS 2005 it uses webservices to integrate.
> On your server open up IIS Manager. Click on each website, right mouse
> click, properties, ASP.Net tab. See if 1.1 or 2.0 and make sure both Reports
> and ReportServer are 1.1
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> news:177B4114-7F1A-459A-ACEE-8BF497DE2BD5@.microsoft.com...
> > Here is something interesting:
> >
> > On the server I typed http://localhost/reportserver
> >
> > and I got a directory listing of all the dirs on the report server and was
> > able to invoke reports directly from here. But when I type
> > http://localhost/reports
> >
> > I get the message that the website declined to show this webpage - http
> > error 403 - IE can connect to the website but doesn't have permission to
> > view
> > the page. Does anyone know what the difference is between the
> > ReportServer
> > virtual dir and the Reports Virtual dir?
> >
> > "Rich" wrote:
> >
> >> Good morning,
> >>
> >> This is a continuation post about a problem I am having where I can't
> >> open
> >> Report Manager. Here is my scenario - win2003 server running Sql Server
> >> 2000
> >> Sp4, RS2000. We were on .Net framework 1.1 but upgraded this last year
> >> to
> >> .Net framework 2.0 so we could use Visual Studio 2005. We still have
> >> Visual
> >> Studio 2003 so that we can use RS2000 designer. I can deploy reports OK,
> >> but
> >> I can't open Report manager - keep gettting varoius HTTP errors, 401,
> >> 403. I
> >> got one error that said the Webpage (for Report Manager) was looking for
> >> .Net
> >> Framework 1.1 and couldn't find it).
> >>
> >> I looked at IIS at the Reports Virtual Dir and the VirtualDir
> >> tabl/Configuration dialog - the application extensions window has all the
> >> extensions looing at .Net Framwork 1.1 which I presume is why I can still
> >> deploy reports. But on the ReportServer virtual dir in the configuration
> >> dialog - the application extensions window is empty, but the Wildcard
> >> Application Extension window has this path:
> >>
> >> C:\Windows\Microsoft.Net\Framework\v1.1.4322\aspnet_isapi.dll
> >>
> >> In the Reports virtual dir/configuration/application extensions window,
> >> the
> >> .aspx extension points to the same path as above. Do I need to add an
> >> extension as above to the the application Extensions window in the
> >> configuration dialog for the ReportServer virtual dir so that Report
> >> Manger
> >> page can run correctly?
> >>
> >> Thanks,
> >> Rich
> >>
>
>|||Don't know if this is of any consequence, but I was looking at Global.asax,
web.config... for each of the directories - Reports and ReportServer from
IIS. I was able to browse all the config files in ReportServer dir, but I
was not able to browse any of the config files or home.aspx from the Reports
dir. Would this have any bearing on anthing?
"Rich" wrote:
> Hi Bruce,
> Thank you again for getting back to me on this (and I appologize in advance
> for being a bonehead, but unfortunately I am one - right now). When I open
> up IIS Manager I go to Websites/Default Website/Reports. I right click on
> Reports/select properties. In this dialog I have 5 tabs - Virtual Directory,
> Documents, Directory Security, HTTP Headers, Custom Errors. I clicked around
> looking for a tab/button for ASP.Net, but did not locate anything.
> Quick note: from my workstation if I type http://myserver/reportserver --
> I can get a directory listing of all the dirs on the report server, I can
> even run reports directly from that page. But if I type
> http://myserver/Reports -- now I get a message that content listing is not
> permitted from this site. It must be a configuration thing. What I lack in
> braincells I compenste for with perseverence. What to configure?
> Thank you for your patience and helping me out.
> Rich
> "Bruce L-C [MVP]" wrote:
> > As I mentioned in one of my last postings to you, I thought it was weird
> > that you could deploy. My thought being that reportserver website might be
> > at 1.1 and reports being at 2.0 framework.
> >
> > Report Manager (reports website) is a portal to Reporting Services. It is
> > just an asp.net application that integrates with ReportServer website/app.
> > Some people do their own front ends and do not even use Report Manager. In
> > RS 2000 Report Manager integrates using URL integration with ReportServer.
> > In RS 2005 it uses webservices to integrate.
> >
> > On your server open up IIS Manager. Click on each website, right mouse
> > click, properties, ASP.Net tab. See if 1.1 or 2.0 and make sure both Reports
> > and ReportServer are 1.1
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Rich" <Rich@.discussions.microsoft.com> wrote in message
> > news:177B4114-7F1A-459A-ACEE-8BF497DE2BD5@.microsoft.com...
> > > Here is something interesting:
> > >
> > > On the server I typed http://localhost/reportserver
> > >
> > > and I got a directory listing of all the dirs on the report server and was
> > > able to invoke reports directly from here. But when I type
> > > http://localhost/reports
> > >
> > > I get the message that the website declined to show this webpage - http
> > > error 403 - IE can connect to the website but doesn't have permission to
> > > view
> > > the page. Does anyone know what the difference is between the
> > > ReportServer
> > > virtual dir and the Reports Virtual dir?
> > >
> > > "Rich" wrote:
> > >
> > >> Good morning,
> > >>
> > >> This is a continuation post about a problem I am having where I can't
> > >> open
> > >> Report Manager. Here is my scenario - win2003 server running Sql Server
> > >> 2000
> > >> Sp4, RS2000. We were on .Net framework 1.1 but upgraded this last year
> > >> to
> > >> .Net framework 2.0 so we could use Visual Studio 2005. We still have
> > >> Visual
> > >> Studio 2003 so that we can use RS2000 designer. I can deploy reports OK,
> > >> but
> > >> I can't open Report manager - keep gettting varoius HTTP errors, 401,
> > >> 403. I
> > >> got one error that said the Webpage (for Report Manager) was looking for
> > >> .Net
> > >> Framework 1.1 and couldn't find it).
> > >>
> > >> I looked at IIS at the Reports Virtual Dir and the VirtualDir
> > >> tabl/Configuration dialog - the application extensions window has all the
> > >> extensions looing at .Net Framwork 1.1 which I presume is why I can still
> > >> deploy reports. But on the ReportServer virtual dir in the configuration
> > >> dialog - the application extensions window is empty, but the Wildcard
> > >> Application Extension window has this path:
> > >>
> > >> C:\Windows\Microsoft.Net\Framework\v1.1.4322\aspnet_isapi.dll
> > >>
> > >> In the Reports virtual dir/configuration/application extensions window,
> > >> the
> > >> .aspx extension points to the same path as above. Do I need to add an
> > >> extension as above to the the application Extensions window in the
> > >> configuration dialog for the ReportServer virtual dir so that Report
> > >> Manger
> > >> page can run correctly?
> > >>
> > >> Thanks,
> > >> Rich
> > >>
> >
> >
> >|||My stress factor has just increased a few points. From IIS
Manager/Help/About it says that I have version 6 also. But I only see 5 tabs
when I right-click on a virtual directory/properties. I guess I am on my
own. Something was obviously not configured during the install of this
server (win2003/IIS/RS...), and I am not quite at the network admin level at
this time to figure this stuff out. Hmmm :(
Well, I have learned a few things, about things that are wrong/incorrect
with my system. And I thank you for mentoring me. I will give this my best
shot and post back if I get any positive results.
Rich
"Bruce L-C [MVP]" wrote:
> I don't know what to tell you. I have 6 tabs, not 5. The 5 you mention and
> then asp.net. My IIS version is version 6.
> I'm afraid you might have more than one thing going on.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> news:351DE8CA-E510-4D78-A8DB-3950BD317190@.microsoft.com...
> > Hi Bruce,
> >
> > Thank you again for getting back to me on this (and I appologize in
> > advance
> > for being a bonehead, but unfortunately I am one - right now). When I
> > open
> > up IIS Manager I go to Websites/Default Website/Reports. I right click on
> > Reports/select properties. In this dialog I have 5 tabs - Virtual
> > Directory,
> > Documents, Directory Security, HTTP Headers, Custom Errors. I clicked
> > around
> > looking for a tab/button for ASP.Net, but did not locate anything.
> >
> > Quick note: from my workstation if I type
> > http://myserver/reportserver --
> > I can get a directory listing of all the dirs on the report server, I can
> > even run reports directly from that page. But if I type
> > http://myserver/Reports -- now I get a message that content listing is
> > not
> > permitted from this site. It must be a configuration thing. What I lack
> > in
> > braincells I compenste for with perseverence. What to configure?
> >
> > Thank you for your patience and helping me out.
> >
> > Rich
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> As I mentioned in one of my last postings to you, I thought it was weird
> >> that you could deploy. My thought being that reportserver website might
> >> be
> >> at 1.1 and reports being at 2.0 framework.
> >>
> >> Report Manager (reports website) is a portal to Reporting Services. It is
> >> just an asp.net application that integrates with ReportServer
> >> website/app.
> >> Some people do their own front ends and do not even use Report Manager.
> >> In
> >> RS 2000 Report Manager integrates using URL integration with
> >> ReportServer.
> >> In RS 2005 it uses webservices to integrate.
> >>
> >> On your server open up IIS Manager. Click on each website, right mouse
> >> click, properties, ASP.Net tab. See if 1.1 or 2.0 and make sure both
> >> Reports
> >> and ReportServer are 1.1
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Rich" <Rich@.discussions.microsoft.com> wrote in message
> >> news:177B4114-7F1A-459A-ACEE-8BF497DE2BD5@.microsoft.com...
> >> > Here is something interesting:
> >> >
> >> > On the server I typed http://localhost/reportserver
> >> >
> >> > and I got a directory listing of all the dirs on the report server and
> >> > was
> >> > able to invoke reports directly from here. But when I type
> >> > http://localhost/reports
> >> >
> >> > I get the message that the website declined to show this webpage - http
> >> > error 403 - IE can connect to the website but doesn't have permission
> >> > to
> >> > view
> >> > the page. Does anyone know what the difference is between the
> >> > ReportServer
> >> > virtual dir and the Reports Virtual dir?
> >> >
> >> > "Rich" wrote:
> >> >
> >> >> Good morning,
> >> >>
> >> >> This is a continuation post about a problem I am having where I can't
> >> >> open
> >> >> Report Manager. Here is my scenario - win2003 server running Sql
> >> >> Server
> >> >> 2000
> >> >> Sp4, RS2000. We were on .Net framework 1.1 but upgraded this last
> >> >> year
> >> >> to
> >> >> .Net framework 2.0 so we could use Visual Studio 2005. We still have
> >> >> Visual
> >> >> Studio 2003 so that we can use RS2000 designer. I can deploy reports
> >> >> OK,
> >> >> but
> >> >> I can't open Report manager - keep gettting varoius HTTP errors, 401,
> >> >> 403. I
> >> >> got one error that said the Webpage (for Report Manager) was looking
> >> >> for
> >> >> .Net
> >> >> Framework 1.1 and couldn't find it).
> >> >>
> >> >> I looked at IIS at the Reports Virtual Dir and the VirtualDir
> >> >> tabl/Configuration dialog - the application extensions window has all
> >> >> the
> >> >> extensions looing at .Net Framwork 1.1 which I presume is why I can
> >> >> still
> >> >> deploy reports. But on the ReportServer virtual dir in the
> >> >> configuration
> >> >> dialog - the application extensions window is empty, but the Wildcard
> >> >> Application Extension window has this path:
> >> >>
> >> >> C:\Windows\Microsoft.Net\Framework\v1.1.4322\aspnet_isapi.dll
> >> >>
> >> >> In the Reports virtual dir/configuration/application extensions
> >> >> window,
> >> >> the
> >> >> .aspx extension points to the same path as above. Do I need to add an
> >> >> extension as above to the the application Extensions window in the
> >> >> configuration dialog for the ReportServer virtual dir so that Report
> >> >> Manger
> >> >> page can run correctly?
> >> >>
> >> >> Thanks,
> >> >> Rich
> >> >>
> >>
> >>
> >>
>
>

Monday, March 12, 2012

How to conenct Ms-Sql server from Unix box.

Hi,
How do conenct Ms-Sql server from Unix/Sun box. currently I am running Ms-Sql 2000 on Nt server witn win2003 . Previously I use to connect Ms-sql server from Unix by using Sybase isql utility but it seems with new version of Sql-Server, it's not working.
Is there any open client /utility provided by Microsoft to connect server from unix machine.
Thanks,
-Uttam
Are you writing a program?
Do you have an ODBC driver installed? You should be able to connect over
that driver through TCP/IP.. Port 1433 is SQL Server's default port to
listen to incoming traffic.
Using the old Sybase method uses the SQL Server/Sybase Tabular Data Stream
format to communicate. (Probably much faster than using standard ODBC, but
ODBC will work). Try looking around for FreeTDS. I think it will support
SQL 2000. I know it supports through SQL Server 7.0.
There may be some security issues as well. You may need to ensure that the
SQL Server is using Mixed Authentication. If it is NT Authentication only,
then you will need a Windows Account mapped in to SQL Server. IIRC
kerberos can be helpful here to validate your UNIX login with an Active
Directory login.
I'm sure someone will correct me if I'm wrong. =)
Rick Sawtell
MCT, MCSD, MCDBA
"Uttam" <Uttam@.discussions.microsoft.com> wrote in message
news:E829C6EF-A04D-41FD-A2A4-ECB935CA9868@.microsoft.com...
> Hi,
> How do conenct Ms-Sql server from Unix/Sun box. currently I am running
Ms-Sql 2000 on Nt server witn win2003 . Previously I use to connect Ms-sql
server from Unix by using Sybase isql utility but it seems with new version
of Sql-Server, it's not working. Is there any open client /utility provided
by Microsoft to connect server from unix machine.
> Thanks,
> -Uttam

How to conenct Ms-Sql server from Unix box.

Hi,
How do conenct Ms-Sql server from Unix/Sun box. currently I am running Ms-Sq
l 2000 on Nt server witn win2003 . Previously I use to connect Ms-sql serve
r from Unix by using Sybase isql utility but it seems with new version of Sq
l-Server, it's not working.
Is there any open client /utility provided by Microsoft to connect server f
rom unix machine.
Thanks,
-UttamAre you writing a program?
Do you have an ODBC driver installed? You should be able to connect over
that driver through TCP/IP.. Port 1433 is SQL Server's default port to
listen to incoming traffic.
Using the old Sybase method uses the SQL Server/Sybase Tabular Data Stream
format to communicate. (Probably much faster than using standard ODBC, but
ODBC will work). Try looking around for FreeTDS. I think it will support
SQL 2000. I know it supports through SQL Server 7.0.
There may be some security issues as well. You may need to ensure that the
SQL Server is using Mixed Authentication. If it is NT Authentication only,
then you will need a Windows Account mapped in to SQL Server. IIRC
kerberos can be helpful here to validate your UNIX login with an Active
Directory login.
I'm sure someone will correct me if I'm wrong. =)
Rick Sawtell
MCT, MCSD, MCDBA
"Uttam" <Uttam@.discussions.microsoft.com> wrote in message
news:E829C6EF-A04D-41FD-A2A4-ECB935CA9868@.microsoft.com...
> Hi,
> How do conenct Ms-Sql server from Unix/Sun box. currently I am running
Ms-Sql 2000 on Nt server witn win2003 . Previously I use to connect Ms-sql
server from Unix by using Sybase isql utility but it seems with new version
of Sql-Server, it's not working. Is there any open client /utility provided
by Microsoft to connect server from unix machine.
> Thanks,
> -Uttam