Connect to SQL Server: access

Showing posts with label access. Show all posts

Tuesday, March 27, 2012

Connecting to SQL Server 2000 thru a VPN?

Is this even possible?
I'm coding a VB.NET WinForms app and an ASP.NET app that will access a MS
SQL 2000 Server. I've been told that when I move into a "production"
environment that I must go thru a VPN. I'm no VPN expert, but this doesn't
make much sense to me especially since the remote clients running my VB.NET
WinForms app may not have teh VPN setup.
If VPN can be used as a tunnel to access a SQL 2000 Server, can someone tell
me what needs to be in place on the client side and what would I use for a
connection string to get to the SQL 2000 Server thru the VPN.
I can't find any info on MSDN that even mentions how to connect to a SQL
2000 Server thru VPN.
Thanks, Rob.
Hi Rob,
The VPN session needs to be established prior to executing your VB.NET
app. There's not a specific connection string to do this.
Here's a sample kb article on how to setup a VPN with our firewall server ,
ISA Server.
837355 How to configure a VPN server by using Internet Security and
http://support.microsoft.com/?id=837355
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Connecting to sql server 2000 in a lan

Hi there,

I have 2 servers on our compny'ssql server does not exist or access denied lan, one with fixed ip and the other one with internal ip. I installed SQL server 2000 on the one with internal ip and I want to access it from the other server. when I want to register sql server instanse , I can see the name of that instance in the list but I can't register it. I keep reciving this error : sql server does not exist or access denied!

Could any one told me what to do?

http://www.connectionstrings.com/

|||

Hi,

According to your problem, the following suggestion may be helpful to you.

1, Does firewall exist in your local network? Please adjust your security level of the Firewall.

2, When connecting to the db server, be sure that the SqlServer is running as well as the 1433 port is opening.

3, Have you installed service pack for your SqlServer2000? Because the port of TCP/IP and UDP is denied due to some security known issue on those edition without service pack.

Thanks.

Connecting to SQL Server 2000

Hi,

I am total newbie to SQL Server. My new host tells me I can connect through
AccessXP or 2002. I have Access 2000. Can I not connect with that also?

Thanks, JAJA wrote:
> Hi,
> I am total newbie to SQL Server. My new host tells me I can connect
> through AccessXP or 2002. I have Access 2000. Can I not connect with
> that also?
> Thanks, JA

Yep, also Access 97, 95, and Access 2.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com|||Rick,

I didn't word that right. Does your answer mean Yes I can, or Yes I can't?

:-)

"Rick Brandt" <rickbrandt2@.hotmail.com> wrote in message
news:346h7iF45hj8fU1@.individual.net...
> JA wrote:
>> Hi,
>>
>> I am total newbie to SQL Server. My new host tells me I can connect
>> through AccessXP or 2002. I have Access 2000. Can I not connect with
>> that also?
>>
>> Thanks, JA
> Yep, also Access 97, 95, and Access 2.
> --
> I don't check the Email account attached
> to this message. Send instead to...
> RBrandt at Hunter dot com|||There are some compatibility problems with ADP-s (Access Data
Project-s) in Access 2000 connecting to a SQL Server 2000. There are no
problems, however if you use MDB-s. Access 2000 ADP-s work best with
SQL Server 7. To use the latest features of SQL Server 2000 you need to
connect with Access XP (2002). For more informations, see:
http://support.microsoft.com/kb/269824

Razvan|||JA wrote:
> Rick,
> I didn't word that right. Does your answer mean Yes I can, or Yes I
> can't?

If you want to you use an Access Data Project then this is available from Access
2000 and up. If you use an MDB with ODBC than you can use any version you want.
All you need is the correct ODBC driver.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

Sunday, March 25, 2012

Connecting to SQL from Within VFP

In this post I am going to try to simply a question that I posted earlier.
Can I use VFP to access a SQL Database? If so what is the command?
What is the best software for creating applications to work with SQL?
I am just getting my feet wet with SQL so please take it easy on a rookie.
You can't expect someone to explain to you how to do all of this properly in
a news group posting. I suggest you read the help file and maybe some books
on VFP and SQL Server. But you can get started with looking up "remote
servers, connecting to" in the VFP help file. Also take a look at Remote
Views as they may be your easiest way to migrate from VFP to SQL Server.
SQL Server is not like VFP in many ways. VFP is mostly a programming
language with a built in DB. SQL Server does not have a programming
language other than SET based stuff and there are no gui's like forms,
dialogs etc.
Andrew J. Kelly SQL MVP
"Preacher Man" <nospam> wrote in message
news:%23PGojbIwFHA.3548@.tk2msftngp13.phx.gbl...
> In this post I am going to try to simply a question that I posted earlier.
> Can I use VFP to access a SQL Database? If so what is the command?
> What is the best software for creating applications to work with SQL?
> I am just getting my feet wet with SQL so please take it easy on a rookie.
>
>
|||Hi Andrew,
Visual FoxPro makes a great front end to SQL Server in much the same way
that Visual Basic, VB.NET, and C# do. Since data-handling is built in to
VFP, all of this capability is available when working with SQL Server.
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden@.msn.com www.cindywinegarden.com
Blog: http://spaces.msn.com/members/cindywinegarden
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:eL6SzpKwFHA.1028@.TK2MSFTNGP12.phx.gbl...
> ...VFP is mostly a programming language with a built in DB. ...
|||Hi,
You're asking how to write Visual FoxPro code in SQL Server newsgroups. You
shouldn't expect SQL Server developers to know the details of programming in
Visual FoxPro, or Visual Basic or C# for that matter. You'll get much better
help in a microsoft.public.fox.* newsgroup on this same news server.
You haven't said which version of Visual FoxPro you're working with. You can
access SQL Server data (or Access or Oracle, or whatever) via ODBC with a
Remote View or SQL Pass-through (SQLConnect or SQLStringConnect, and
SQLExec). You can also access SQL Server via OLE DB and ADO using a
CursorAdapter.
As for which is the best software for accessing SQL Server data, that
depends. Often the "best" software is the one that you're most comfortable
with. Visual FoxPro makes a great front end to SQL Server and brings all of
its built-in data handling capabilities to the table.
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden@.msn.com www.cindywinegarden.com
Blog: http://spaces.msn.com/members/cindywinegarden
"Preacher Man" <nospam> wrote in message
news:%23PGojbIwFHA.3548@.tk2msftngp13.phx.gbl...
> In this post I am going to try to simply a question that I posted earlier.
> Can I use VFP to access a SQL Database? If so what is the command?
> What is the best software for creating applications to work with SQL?
> I am just getting my feet wet with SQL so please take it easy on a rookie.
>
>
|||Cindy,
Lest you forget I have been programming with VFP since it was in Beta for
3.0. I never stated that VFP was not a valid choice for a front end. If you
look at my post I sent him to the very same places you did in your other
post.
Andrew J. Kelly SQL MVP
"Cindy Winegarden" <cindy_winegarden@.msn.com> wrote in message
news:eCb9kwWwFHA.596@.TK2MSFTNGP12.phx.gbl...
> Hi Andrew,
> Visual FoxPro makes a great front end to SQL Server in much the same way
> that Visual Basic, VB.NET, and C# do. Since data-handling is built in to
> VFP, all of this capability is available when working with SQL Server.
> --
> Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
> cindy_winegarden@.msn.com www.cindywinegarden.com
> Blog: http://spaces.msn.com/members/cindywinegarden
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:eL6SzpKwFHA.1028@.TK2MSFTNGP12.phx.gbl...
>

Connecting to SQL from Within VFP

In this post I am going to try to simply a question that I posted earlier.
Can I use VFP to access a SQL Database? If so what is the command?
What is the best software for creating applications to work with SQL?
I am just getting my feet wet with SQL so please take it easy on a rookie.You can't expect someone to explain to you how to do all of this properly in
a news group posting. I suggest you read the help file and maybe some books
on VFP and SQL Server. But you can get started with looking up "remote
servers, connecting to" in the VFP help file. Also take a look at Remote
Views as they may be your easiest way to migrate from VFP to SQL Server.
SQL Server is not like VFP in many ways. VFP is mostly a programming
language with a built in DB. SQL Server does not have a programming
language other than SET based stuff and there are no gui's like forms,
dialogs etc.
Andrew J. Kelly SQL MVP
"Preacher Man" <nospam> wrote in message
news:%23PGojbIwFHA.3548@.tk2msftngp13.phx.gbl...
> In this post I am going to try to simply a question that I posted earlier.
> Can I use VFP to access a SQL Database? If so what is the command?
> What is the best software for creating applications to work with SQL?
> I am just getting my feet wet with SQL so please take it easy on a rookie.
>
>|||Hi Andrew,
Visual FoxPro makes a great front end to SQL Server in much the same way
that Visual Basic, VB.NET, and C# do. Since data-handling is built in to
VFP, all of this capability is available when working with SQL Server.
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden@.msn.com www.cindywinegarden.com
Blog: http://spaces.msn.com/members/cindywinegarden
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:eL6SzpKwFHA.1028@.TK2MSFTNGP12.phx.gbl...
> ...VFP is mostly a programming language with a built in DB. ...|||Hi,
You're asking how to write Visual FoxPro code in SQL Server newsgroups. You
shouldn't expect SQL Server developers to know the details of programming in
Visual FoxPro, or Visual Basic or C# for that matter. You'll get much better
help in a microsoft.public.fox.* newsgroup on this same news server.
You haven't said which version of Visual FoxPro you're working with. You can
access SQL Server data (or Access or Oracle, or whatever) via ODBC with a
Remote View or SQL Pass-through (SQLConnect or SQLStringConnect, and
SQLExec). You can also access SQL Server via OLE DB and ADO using a
CursorAdapter.
As for which is the best software for accessing SQL Server data, that
depends. Often the "best" software is the one that you're most comfortable
with. Visual FoxPro makes a great front end to SQL Server and brings all of
its built-in data handling capabilities to the table.
Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy_winegarden@.msn.com www.cindywinegarden.com
Blog: http://spaces.msn.com/members/cindywinegarden
"Preacher Man" <nospam> wrote in message
news:%23PGojbIwFHA.3548@.tk2msftngp13.phx.gbl...
> In this post I am going to try to simply a question that I posted earlier.
> Can I use VFP to access a SQL Database? If so what is the command?
> What is the best software for creating applications to work with SQL?
> I am just getting my feet wet with SQL so please take it easy on a rookie.
>
>|||Cindy,
Lest you forget I have been programming with VFP since it was in Beta for
3.0. I never stated that VFP was not a valid choice for a front end. If you
look at my post I sent him to the very same places you did in your other
post.
Andrew J. Kelly SQL MVP
"Cindy Winegarden" <cindy_winegarden@.msn.com> wrote in message
news:eCb9kwWwFHA.596@.TK2MSFTNGP12.phx.gbl...
> Hi Andrew,
> Visual FoxPro makes a great front end to SQL Server in much the same way
> that Visual Basic, VB.NET, and C# do. Since data-handling is built in to
> VFP, all of this capability is available when working with SQL Server.
> --
> Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
> cindy_winegarden@.msn.com www.cindywinegarden.com
> Blog: http://spaces.msn.com/members/cindywinegarden
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:eL6SzpKwFHA.1028@.TK2MSFTNGP12.phx.gbl...
>

Connecting to SQL from Access

I have users who currently query a SQL database using Access and an odbc
connection. The database is being moved to a less secure server, and we are
looking for the best way for users to connect to this database so they can
do their own queries. They like Access because they can select the tables
and don't have to remember t-sql code, and I wouldn't want to give them sql
query anaylizer anyway. What would be the best way to do this? Eventually
we will be creating programs for them to access their data, but that could
be a long time in coming, and there are always queries we cannot anticipate
and therefore cannot provide an application for.
Thanks. Any ideas are appreciated.Access works pretty well. We've used access project files (.adp) to
allow users to query databases. .adp files utilize OLE DB connections.
You can also appropriately permission the login that the Access .adp
uses to access the sql server database. Let me know if you need more
specific guidance, I'd be happy to help out.|||Access works pretty well. We've used access project files (.adp) to
allow users to query databases. .adp files utilize OLE DB connections.
You can also appropriately permission the login that the Access .adp
uses to access the sql server database. Let me know if you need more
specific guidance, I'd be happy to help out.

connecting to SQL express through VB

Hi all,

I have SQL server express edition 2005 installed on my computer and using VB in MS Access to run some queries. The VB function looks something like this..

Dim dataRS As New ADODB.Recordset
Dim cnnSQL As New ADODB.Connection

Set cnnSQL = New ADODB.Connection
cnnSQL.ConnectionString = "Provider=SQLNCLI;Server=.\SQLExpress;Database=TestDB;Trusted_Connection=yes;"

cnnSQL.Properties("Integrated Security").Value = "SSPI"
cnnSQL.Open

dataRS.Open "SELECT dbo_Table_1.* FROM dbo_Table_1", cnnSQL, adOpenStatic, adLockOptimistic

The code fails on the last line with message
"Invalid object name 'dbo_Table_1'"
(yes, I verified that the table actually does exist in the DB)

I must be doing something wrong with the connection string but all the things that I've tried so far haven't worked.. Can anyone offer any suggestions?

Thanks in advance,

Try providing the schema name for the table in your select statement, as in:

SELECT DBO.dbo_Table1.* FROM DBO.dbo_Table1

You schema may or may not be DBO, I just use that here as an example.

Mike

Connecting to SQL dbfs with existing code

We recently moved our Access databases to SQL and are
trying to get our pages to open the connections to the
server. I've set the system DSNs on the server as needed.
However, no connections are made. After reviewing several
books, microsoft.com, etc...I'm severely frustrated. The
only thing I can think that would possibly be an issue is
that our webserver (Win2003) is not setup as a Primary
Domain Server and we have to connect via http.
Any suggestions are appreciated. THANKS!Does the System DSN connect if you Test it from the IIS server?
If not what is the OS error returned?
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Connecting to SQL Data (MSCRM) with access

I am looking to connect to my SQL Server to access the contacts along with
the notes from my Microsoft CRM Database. We need to export all contacts and
notes via CRM and import in Goldmine. Any ideas or reference....
Does this CRM application have an export/transfer feature? Do you know what
table(s) contain the contacts and notes - could use DTS or custom script
out--> view for import into Goldmine.
HTH
Jerry
"KMD" <KMD@.discussions.microsoft.com> wrote in message
news:6786C92E-5C59-4524-9268-1690B667C213@.microsoft.com...
>I am looking to connect to my SQL Server to access the contacts along with
> the notes from my Microsoft CRM Database. We need to export all contacts
> and
> notes via CRM and import in Goldmine. Any ideas or reference....

Connecting to SQL Data (MSCRM) with access

I am looking to connect to my SQL Server to access the contacts along with
the notes from my Microsoft CRM Database. We need to export all contacts and
notes via CRM and import in Goldmine. Any ideas or reference....Does this CRM application have an export/transfer feature? Do you know what
table(s) contain the contacts and notes - could use DTS or custom script
out--> view for import into Goldmine.
HTH
Jerry
"KMD" <KMD@.discussions.microsoft.com> wrote in message
news:6786C92E-5C59-4524-9268-1690B667C213@.microsoft.com...
>I am looking to connect to my SQL Server to access the contacts along with
> the notes from my Microsoft CRM Database. We need to export all contacts
> and
> notes via CRM and import in Goldmine. Any ideas or reference....sql sql

Connecting to SQL Data (MSCRM) with access

I am looking to connect to my SQL Server to access the contacts along with
the notes from my Microsoft CRM Database. We need to export all contacts an
d
notes via CRM and import in Goldmine. Any ideas or reference....Does this CRM application have an export/transfer feature? Do you know what
table(s) contain the contacts and notes - could use DTS or custom script
out--> view for import into Goldmine.
HTH
Jerry
"KMD" <KMD@.discussions.microsoft.com> wrote in message
news:6786C92E-5C59-4524-9268-1690B667C213@.microsoft.com...
>I am looking to connect to my SQL Server to access the contacts along with
> the notes from my Microsoft CRM Database. We need to export all contacts
> and
> notes via CRM and import in Goldmine. Any ideas or reference....

Thursday, March 22, 2012

Connecting to SQL

I have a problem in connecting to an SQL database on a server from laptop
computers. The users can access it from a desktop with same windows login as
they use on their laptop but all I get when they try on the laptop is an
error message saying connection failure. All machines are running XP and we
cannot find any differences in the setup.
If anyone has any advise or can point me in the right direction I would be
greatful.
TIA
Rob
Hi Rob,
Do you use sqlserver authentication or windows authentication on the
sqlserver ?
Ton
"Rob Fenn" <robfenn.mp@.nospamntlworld.com> wrote in message
news:OGxRj9rtEHA.2664@.TK2MSFTNGP12.phx.gbl...
> I have a problem in connecting to an SQL database on a server from laptop
> computers. The users can access it from a desktop with same windows login
as
> they use on their laptop but all I get when they try on the laptop is an
> error message saying connection failure. All machines are running XP and
we
> cannot find any differences in the setup.
> If anyone has any advise or can point me in the right direction I would be
> greatful.
> TIA
> Rob
>
>
|||windows authentication. Although this has been partly resolved. The laptops
have been assigned fixed IP addresses which has allowed them to connect.
However I would ideally prefer a different workaround as fixed IP addresses
are not ideal.
Thanks
"Ton" <t.leer@.wanadoo.nl> wrote in message
news:4176ad6b$0$30709$18b6e80@.news.wanadoo.nl...
> Hi Rob,
> Do you use sqlserver authentication or windows authentication on the
> sqlserver ?
> Ton
> "Rob Fenn" <robfenn.mp@.nospamntlworld.com> wrote in message
> news:OGxRj9rtEHA.2664@.TK2MSFTNGP12.phx.gbl...
> as
> we
>
|||This is a DNS issue and is not really related to SQL Server.
Michael Otey
"Rob Fenn" <robfenn.mp@.nospamntlworld.com> wrote in message
news:O1Ljfq4tEHA.2316@.TK2MSFTNGP12.phx.gbl...
> windows authentication. Although this has been partly resolved. The
laptops
> have been assigned fixed IP addresses which has allowed them to connect.
> However I would ideally prefer a different workaround as fixed IP
addresses[vbcol=seagreen]
> are not ideal.
> Thanks
> "Ton" <t.leer@.wanadoo.nl> wrote in message
> news:4176ad6b$0$30709$18b6e80@.news.wanadoo.nl...
laptop[vbcol=seagreen]
login[vbcol=seagreen]
an[vbcol=seagreen]
and
>

Connecting to SQL

I have a problem in connecting to an SQL database on a server from laptop
computers. The users can access it from a desktop with same windows login as
they use on their laptop but all I get when they try on the laptop is an
error message saying connection failure. All machines are running XP and we
cannot find any differences in the setup.
If anyone has any advise or can point me in the right direction I would be
greatful.
TIA
RobHi Rob,
Do you use sqlserver authentication or windows authentication on the
sqlserver ?
Ton
"Rob Fenn" <robfenn.mp@.nospamntlworld.com> wrote in message
news:OGxRj9rtEHA.2664@.TK2MSFTNGP12.phx.gbl...
> I have a problem in connecting to an SQL database on a server from laptop
> computers. The users can access it from a desktop with same windows login
as
> they use on their laptop but all I get when they try on the laptop is an
> error message saying connection failure. All machines are running XP and
we
> cannot find any differences in the setup.
> If anyone has any advise or can point me in the right direction I would be
> greatful.
> TIA
> Rob
>
>|||windows authentication. Although this has been partly resolved. The laptops
have been assigned fixed IP addresses which has allowed them to connect.
However I would ideally prefer a different workaround as fixed IP addresses
are not ideal.
Thanks
"Ton" <t.leer@.wanadoo.nl> wrote in message
news:4176ad6b$0$30709$18b6e80@.news.wanadoo.nl...
> Hi Rob,
> Do you use sqlserver authentication or windows authentication on the
> sqlserver ?
> Ton
> "Rob Fenn" <robfenn.mp@.nospamntlworld.com> wrote in message
> news:OGxRj9rtEHA.2664@.TK2MSFTNGP12.phx.gbl...
> as
> we
>|||This is a DNS issue and is not really related to SQL Server.
Michael Otey
"Rob Fenn" <robfenn.mp@.nospamntlworld.com> wrote in message
news:O1Ljfq4tEHA.2316@.TK2MSFTNGP12.phx.gbl...
> windows authentication. Although this has been partly resolved. The
laptops
> have been assigned fixed IP addresses which has allowed them to connect.
> However I would ideally prefer a different workaround as fixed IP
addresses
> are not ideal.
> Thanks
> "Ton" <t.leer@.wanadoo.nl> wrote in message
> news:4176ad6b$0$30709$18b6e80@.news.wanadoo.nl...
laptop[vbcol=seagreen]
login[vbcol=seagreen]
an[vbcol=seagreen]
and[vbcol=seagreen]
>

Connecting to reporting services

I am trying to connect to my reporting services. I keep getting the following error. I am in the sysadmin role What else do I need access to in order to connect?
TIA,
Joe
TITLE: Connect to Server

Cannot connect to ENSQLD1\ENSQLD1_2005.

ADDITIONAL INFORMATION:

The request failed with HTTP status 401: Access Denied. (Microsoft.SqlServer.Management.UI.RSClient)

BUTTONS:

Are you a local system admin to the Report Server? If not then a local admin will have to grant you rights to the Report server. The Database roles have no meaning to the Report Server service.

-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.sql sql

Connecting to reporting services

I am trying to connect to my reporting services. I keep getting the following error. I am in the sysadmin role What else do I need access to in order to connect?
TIA,
Joe
TITLE: Connect to Server

Cannot connect to ENSQLD1\ENSQLD1_2005.

ADDITIONAL INFORMATION:

The request failed with HTTP status 401: Access Denied. (Microsoft.SqlServer.Management.UI.RSClient)

BUTTONS:

OKAre you a local system admin to the Report Server? If not then a local admin will have to grant you rights to the Report server. The Database roles have no meaning to the Report Server service.

-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.

Monday, March 19, 2012

Connecting to MSDE via client

Hope someone can explain why this happened.
I installed MSDE on a Winxp workstation.
I then setup clients to access MSDE via TCP/IP using the (Static) IP Address
address of the workstation.
Connection successful
I then removed MSDE2000 and installed MSDE2000 sp3a
Went I to connect to MSDE via TCP/IP and could not connect using the IP
When I changed to The machine name I could connect to MSDE2000
Anyone with any idea.
Server was winXP and workstations Win98 and Win08se.
Regards
Jeff
--
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.538 / Virus Database: 333 - Release Date: 10/11/2003Jeff Williams wrote:
> Hope someone can explain why this happened.
> I installed MSDE on a Winxp workstation.
> I then setup clients to access MSDE via TCP/IP using the (Static) IP
> Address address of the workstation.
> Connection successful
> I then removed MSDE2000 and installed MSDE2000 sp3a
> Went I to connect to MSDE via TCP/IP and could not connect using the
> IP When I changed to The machine name I could connect to MSDE2000
> Anyone with any idea.
> Server was winXP and workstations Win98 and Win08se.
> Regards
> Jeff
>
> --
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.538 / Virus Database: 333 - Release Date: 10/11/2003
Check that the Server (via sql server network utility) is configured to
use TCP/IP. Also check your client is configured like this too (client
network utility).
Br,
Mark Broadbent
mcdba , mcse+i
=============

Connecting to MSDE

Being new to the SQL server world I have a beginner question.

How do I grant access to database from a networked computer?
I have tried:
sp_grantlogin '\\computername\username'
and I get the error:
Windows NT or user <above> not found. Please check name.

Any help would be appreciated.
Thanks
EricEric Borden (borden_eric@.invalid.com) writes:
> Being new to the SQL server world I have a beginner question.
> How do I grant access to database from a networked computer?
> I have tried:
> sp_grantlogin '\\computername\username'
> and I get the error:
> Windows NT or user <above> not found. Please check name.

This not really my area, but I believe that SQL Server needs to be
able to verify that the user exists. If the user is in the same domain
as SQL Server this is trivial. But if all you have a workgroup, and
not a domain, things are getting difficult. In this case, SQL authentication
may be required.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

Tuesday, March 27, 2012

Connecting to SQL Server 2000 thru a VPN?

Connecting to sql server 2000 in a lan

Connecting to SQL Server 2000

Sunday, March 25, 2012

Connecting to SQL from Within VFP

Connecting to SQL from Within VFP

Connecting to SQL from Within VFP

Connecting to SQL from Within VFP

Connecting to SQL from Within VFP

Connecting to SQL from Access

connecting to SQL express through VB

Connecting to SQL dbfs with existing code

Connecting to SQL Data (MSCRM) with access

Connecting to SQL Data (MSCRM) with access

Connecting to SQL Data (MSCRM) with access

Thursday, March 22, 2012

Connecting to SQL

Connecting to SQL

Connecting to reporting services

Connecting to reporting services

Monday, March 19, 2012

Connecting to MSDE via client

Connecting to MSDE

Connect to SQL Server

Blog Archive

About Me