RE: SQL Server Access
- From: v-chayan@xxxxxxxxxxxxxxxxxxxx ("Charles Yang [MSFT]")
- Date: Wed, 17 Aug 2005 03:43:20 GMT
HI,
Thanks for your good sharing in this newsgroup, many of the customer will
have a good experience, please feel free here.
Have a nice day!
Best regards,
Charles Yang (MSFT)
Microsoft CSS Online Newsgroup Support
Get Secure! - www.microsoft.com/security
======================================================
This newsgroup only focuses on SBS technical issues. If you have issues
regarding other Microsoft products, you'd better post in the corresponding
newsgroups so that they can be resolved in an efficient and timely manner.
You can locate the newsgroup here:
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx
When opening a new thread via the web interface, we recommend you check the
"Notify me of replies" box to receive e-mail notifications when there are
any updates in your thread. When responding to posts via your newsreader,
please "Reply to Group" so that others may learn and benefit from your
issue.
Microsoft engineers can only focus on one issue per thread. Although we
provide other information for your reference, we recommend you post
different incidents in different threads to keep the thread clean. In doing
so, it will ensure your issues are resolved in a timely manner.
For urgent issues, you may want to contact Microsoft CSS directly. Please
check http://support.microsoft.com for regional support phone numbers.
Any input or comments in this thread are highly appreciated.
======================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
| Thread-Topic: SQL Server Access
| thread-index: AcWiXdEbktUISxUGQxKNDmdIqtL9yg==
| X-WBNR-Posting-Host: 83.89.95.17
| From: =?Utf-8?B?SmVzcGVyIEhhdWdl?= <JesperHauge@xxxxxxxxxxxxxxxxxxxxxxxxx>
| References: <B699F59B-9BF6-4D80-8C8A-43FC22CDED18@xxxxxxxxxxxxx>
| Subject: RE: SQL Server Access
| Date: Tue, 16 Aug 2005 05:27:07 -0700
| Lines: 38
| Message-ID: <CBCC0DF8-42E5-4966-B7AA-78770C94EE65@xxxxxxxxxxxxx>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.windows.server.sbs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.windows.server.sbs:144840
| X-Tomcat-NG: microsoft.public.windows.server.sbs
|
| I've figured it out for myself - problem was not in the Access control as
i
| thought. The server has multiple IP-addresses, turns out that the
SBS-did'nt
| assign the servers network name to the same IP-adress as previously, so
the
| SQL-server is not listening on the IP-address the SBS-server has
registered
| in the WINS database.
|
| Sorry for the inconveniece.
|
| .Jesper
|
| "Jesper Hauge" wrote:
|
| > Hello all
| >
| > I've recently switched from a P2P workgroup to a SBS2003 Domain.
Basically
| > I've installed a new server runnning SBS, and then used
| > sbsserver/connectcomputer to add my existing workstations and Windows
2003
| > server to the domain.
| >
| > My problem is that I am no longer able to connect to the SQL server
running
| > on the other Win2003 server via Enteprise manager on my workstation.
Heres
| > what I have already tried:
| >
| > - I've checked that the SQL server is communication via TCP/IP on port
1433,
| > I can connect via telnet to port 1433 on the server.
| >
| > - I've added the "domain\Power Users" group of which my windows account
is a
| > member to the "security/logins" section of the enterprise manager on
the
| > server and checked the "System administrators" role for this group.
| >
| > - I've tried using the "sa" account for remote access via Enterprise
Manager
| > and Query Analyzer, but I recieve the same error message as when I am
using
| > my windows account.
| >
| > What am I missing? Help and comments very much appreciated.
| >
| > Regards
| > Jesper Hauge
|
.
- References:
- SQL Server Access
- From: Jesper Hauge
- RE: SQL Server Access
- From: Jesper Hauge
- SQL Server Access
- Prev by Date: RE: Scorecard Manager 2005
- Next by Date: Re: Understanding WSUS
- Previous by thread: RE: SQL Server Access
- Next by thread: Problems when offer remote assistance
- Index(es):
Relevant Pages
|
