LIMIT problems: failed

Showing posts with label failed. Show all posts

Wednesday, March 28, 2012

LINK SQL SERVER DATABASE FROM ACCESS

i tried link to sql server db from access and i failed... (What is my
fault.. I think It doenst ask me catalog -database name so it doesnt accept
my username and password..It cant find my username and password which
database has it ..)
i follewed these steps...
1.right click and link table
2.chooes types of data -->ODBC Databases
3.Machine(or Computer) Data Source and Click New from here..
4.Choose User Data Source and click NEXT
5.Chooes SQL Server and click NEXT
6.Click END
7.enter Server IP description and Name and click NEXT
8.Chooes Sql Server Authentication and Username and password of my catalog
database... and CLICK NEXT
9.SQL State='010000'
Sql Server Failure:10060
[microsoft [[ODBC SQL Server Driver][TCP/IP Sockets] ConnectionOpen
(Connect())
Connection failed
Sql State: '08001'
Sql Server Failure:17
[microsoft [[ODBC SQL Server Driver][TCP/IP Sockets] Sql server doesnt
exists or access denied..
how can i solve it or can link a sql server databaseProblem lies in either step 7 or step 8.
Step 7: where is the SQL Server located? If it is on your local network,
simply enter "SeverName" or "ServerName\SQLInstanceName", If it is on an
WinXP Pro with SP2, does the TCP/IP port (1433) is allowed through the
firewall (if it is enabled).
If your are sure the network setup is correct, then it is Step 8: you did
not give correct login credential. SQL Server uses Win security (no need to
supply username/password) or SQL Security (you must supply username/pswd).
However, even your login credential is correct, it does not necessarily mean
that you can access a database on the SL Server. The administrator can give
or deny access to a database for a login (whether it is Win Security or SQL
Security). You may have check with the DB administrator to make sure the
login you use has access to the database.
"Savas Ates" <savas@.indexinteractive.com> wrote in message
news:OynZrvtNFHA.2704@.TK2MSFTNGP15.phx.gbl...
> i tried link to sql server db from access and i failed... (What is my
> fault.. I think It doenst ask me catalog -database name so it doesnt
accept
> my username and password..It cant find my username and password which
> database has it ..)
> i follewed these steps...
> 1.right click and link table
> 2.chooes types of data -->ODBC Databases
> 3.Machine(or Computer) Data Source and Click New from here..
> 4.Choose User Data Source and click NEXT
> 5.Chooes SQL Server and click NEXT
> 6.Click END
> 7.enter Server IP description and Name and click NEXT
> 8.Chooes Sql Server Authentication and Username and password of my
catalog
> database... and CLICK NEXT
> 9.SQL State='010000'
> Sql Server Failure:10060
> [microsoft [[ODBC SQL Server Driver][TCP/IP Sockets] ConnectionOpen
> (Connect())
> Connection failed
> Sql State: '08001'
> Sql Server Failure:17
> [microsoft [[ODBC SQL Server Driver][TCP/IP Sockets] Sql server doesnt
> exists or access denied..
> how can i solve it or can link a sql server database
>
>
>|||my sql server is not in local network.. it is in remote network... and its
ip , username and password is true...
coz i can access it from enterprise manager from my local sql server...
i looked at my permissions.. from users in my database ...
in my dbo public and db_owner permit checked... what is tthe problem ?
tried link to sql server db from access and i failed... (What is my
fault.. I think It doenst ask me catalog -database name so it doesnt accept
my username and password..It cant find my username and password which
database has it ..)
i follewed these steps...
1.right click and link table
2.chooes types of data -->ODBC Databases
3.Machine(or Computer) Data Source and Click New from here..
4.Choose User Data Source and click NEXT
5.Chooes SQL Server and click NEXT
6.Click END
7.enter Server IP description and Name and click NEXT
8.Chooes Sql Server Authentication and Username and password of my catalog
database... and CLICK NEXT
9.SQL State='010000'
Sql Server Failure:10060
[microsoft [[ODBC SQL Server Driver][TCP/IP Sockets] ConnectionOpen
(Connect())
Connection failed
Sql State: '08001'
Sql Server Failure:17
[microsoft [[ODBC SQL Server Driver][TCP/IP Sockets] Sql server doesnt
exists or access denied..
how can i solve it or can link a sql server database|||So, your Enterprise Manager is connected to this remove SQL Server. Then it
is Step 8. it must be the username/password, which is an Login's
authentication credential.
In your EM, go to the "SQL Server->Security->Logins", right-click the login
you are to use and select "Prooerties". Select tab "Database Access" and
check one or more database you'd like this login to have access and set
appropriate database roles. Also, you may want to reset this login's
password to make sure you'll use correct password.
After this, you can retry to create an ODBC data source name for the Access
linking.
"Savas Ates" <savas@.indexinteractive.com> wrote in message
news:#w39Rq4NFHA.3336@.TK2MSFTNGP10.phx.gbl...
> my sql server is not in local network.. it is in remote network... and its
> ip , username and password is true...
> coz i can access it from enterprise manager from my local sql server...
> i looked at my permissions.. from users in my database ...
> in my dbo public and db_owner permit checked... what is tthe problem ?
>
>
> tried link to sql server db from access and i failed... (What is my
> fault.. I think It doenst ask me catalog -database name so it doesnt
accept
> my username and password..It cant find my username and password which
> database has it ..)
> i follewed these steps...
> 1.right click and link table
> 2.chooes types of data -->ODBC Databases
> 3.Machine(or Computer) Data Source and Click New from here..
> 4.Choose User Data Source and click NEXT
> 5.Chooes SQL Server and click NEXT
> 6.Click END
> 7.enter Server IP description and Name and click NEXT
> 8.Chooes Sql Server Authentication and Username and password of my
catalog
> database... and CLICK NEXT
> 9.SQL State='010000'
> Sql Server Failure:10060
> [microsoft [[ODBC SQL Server Driver][TCP/IP Sockets] ConnectionOpen
> (Connect())
> Connection failed
> Sql State: '08001'
> Sql Server Failure:17
> [microsoft [[ODBC SQL Server Driver][TCP/IP Sockets] Sql server doesnt
> exists or access denied..
> how can i solve it or can link a sql server database
>
>|||i made what u said but there is not any tab database access .. There is
only general Tab...
what i must do ?
"Norman Yuan" <NotReal@.NotReal.not>, haber iletisinde unlar
yazd:uA6Iy86NFHA.3296@.TK2MSFTNGP15.phx.gbl...
> So, your Enterprise Manager is connected to this remove SQL Server. Then
> it
> is Step 8. it must be the username/password, which is an Login's
> authentication credential.
> In your EM, go to the "SQL Server->Security->Logins", right-click the
> login
> you are to use and select "Prooerties". Select tab "Database Access" and
> check one or more database you'd like this login to have access and set
> appropriate database roles. Also, you may want to reset this login's
> password to make sure you'll use correct password.
> After this, you can retry to create an ODBC data source name for the
> Access
> linking.
>|||Are you sure you clicked correct object?
It is the node on left: Console Root->Microsoft SQL Server->SQL Server
Group->(server name)->Security->Logins".
On right, right click any Login listed and "Properties". The "Properties"
dialog has three tabs: "General", "Server Roles" and "Database Access".
If you did not see three tab, are you really using Enterprise Manager?, or
you right-clicked a user under database, which "Properties" dialog has only
"General" tab.
"Savas Ates" <savas@.indexinteractive.com> wrote in message
news:e#dQ0heOFHA.3808@.TK2MSFTNGP14.phx.gbl...
> i made what u said but there is not any tab database access .. There is
> only general Tab...
> what i must do ?
>
> "Norman Yuan" <NotReal@.NotReal.not>, haber iletisinde unlar
> yazd:uA6Iy86NFHA.3296@.TK2MSFTNGP15.phx.gbl...
>|||my database is a remote one.. i right click other users i see only help
dialog..
i right click my user and i click and i can see properties dialog..i see
only general tab.. can it be due to my admin's settings.. what he and i must
do solve this problem... sure i user enteprrise manager by the way :)
when i open my database-->users--> on the right side i can see dbo... i
right click and chooes properties .. but i cant change my settings (i see
only general tab.. )
dont forget that my first attemp is not same with this.. i made what u said
truly...
by the way which roles or permission must be given my database ?
"Norman Yuan" <NotReal@.NotReal.not>, haber iletisinde unlar
yazd:uUF1Z1eOFHA.1528@.TK2MSFTNGP09.phx.gbl...
> Are you sure you clicked correct object?
> It is the node on left: Console Root->Microsoft SQL Server->SQL Server
> Group->(server name)->Security->Logins".
> On right, right click any Login listed and "Properties". The "Properties"
> dialog has three tabs: "General", "Server Roles" and "Database Access".
> If you did not see three tab, are you really using Enterprise Manager?, or
> you right-clicked a user under database, which "Properties" dialog has
> only
> "General" tab.
>

LINK SQL SERVER DATABASE FROM ACCESS

i tried link to sql server db from access and i failed... (What is my
fault.. I think It doenst ask me catalog -database name so it doesnt accept
my username and password..It cant find my username and password which
database has it ..)
i follewed these steps...
1.right click and link table
2.chooes types of data -->ODBC Databases
3.Machine(or Computer) Data Source and Click New from here..
4.Choose User Data Source and click NEXT
5.Chooes SQL Server and click NEXT
6.Click END
7.enter Server IP description and Name and click NEXT
8.Chooes Sql Server Authentication and Username and password of my catalog
database... and CLICK NEXT
9.SQL State='010000'
Sql Server Failure:10060
[microsoft [[ODBC SQL Server Driver][TCP/IP Sockets] ConnectionOpen
(Connect())
Connection failed
Sql State: '08001'
Sql Server Failure:17
[microsoft [[ODBC SQL Server Driver][TCP/IP Sockets] Sql server doesnt
exists or access denied..
how can i solve it or can link a sql server database
Problem lies in either step 7 or step 8.
Step 7: where is the SQL Server located? If it is on your local network,
simply enter "SeverName" or "ServerName\SQLInstanceName", If it is on an
WinXP Pro with SP2, does the TCP/IP port (1433) is allowed through the
firewall (if it is enabled).
If your are sure the network setup is correct, then it is Step 8: you did
not give correct login credential. SQL Server uses Win security (no need to
supply username/password) or SQL Security (you must supply username/pswd).
However, even your login credential is correct, it does not necessarily mean
that you can access a database on the SL Server. The administrator can give
or deny access to a database for a login (whether it is Win Security or SQL
Security). You may have check with the DB administrator to make sure the
login you use has access to the database.
"Savas Ates" <savas@.indexinteractive.com> wrote in message
news:OynZrvtNFHA.2704@.TK2MSFTNGP15.phx.gbl...
> i tried link to sql server db from access and i failed... (What is my
> fault.. I think It doenst ask me catalog -database name so it doesnt
accept
> my username and password..It cant find my username and password which
> database has it ..)
> i follewed these steps...
> 1.right click and link table
> 2.chooes types of data -->ODBC Databases
> 3.Machine(or Computer) Data Source and Click New from here..
> 4.Choose User Data Source and click NEXT
> 5.Chooes SQL Server and click NEXT
> 6.Click END
> 7.enter Server IP description and Name and click NEXT
> 8.Chooes Sql Server Authentication and Username and password of my
catalog
> database... and CLICK NEXT
> 9.SQL State='010000'
> Sql Server Failure:10060
> [microsoft [[ODBC SQL Server Driver][TCP/IP Sockets] ConnectionOpen
> (Connect())
> Connection failed
> Sql State: '08001'
> Sql Server Failure:17
> [microsoft [[ODBC SQL Server Driver][TCP/IP Sockets] Sql server doesnt
> exists or access denied..
> how can i solve it or can link a sql server database
>
>
>
|||my sql server is not in local network.. it is in remote network... and its
ip , username and password is true...
coz i can access it from enterprise manager from my local sql server...
i looked at my permissions.. from users in my database ...
in my dbo public and db_owner permit checked... what is tthe problem ?
tried link to sql server db from access and i failed... (What is my
fault.. I think It doenst ask me catalog -database name so it doesnt accept
my username and password..It cant find my username and password which
database has it ..)
i follewed these steps...
1.right click and link table
2.chooes types of data -->ODBC Databases
3.Machine(or Computer) Data Source and Click New from here..
4.Choose User Data Source and click NEXT
5.Chooes SQL Server and click NEXT
6.Click END
7.enter Server IP description and Name and click NEXT
8.Chooes Sql Server Authentication and Username and password of my catalog
database... and CLICK NEXT
9.SQL State='010000'
Sql Server Failure:10060
[microsoft [[ODBC SQL Server Driver][TCP/IP Sockets] ConnectionOpen
(Connect())
Connection failed
Sql State: '08001'
Sql Server Failure:17
[microsoft [[ODBC SQL Server Driver][TCP/IP Sockets] Sql server doesnt
exists or access denied..
how can i solve it or can link a sql server database
|||So, your Enterprise Manager is connected to this remove SQL Server. Then it
is Step 8. it must be the username/password, which is an Login's
authentication credential.
In your EM, go to the "SQL Server->Security->Logins", right-click the login
you are to use and select "Prooerties". Select tab "Database Access" and
check one or more database you'd like this login to have access and set
appropriate database roles. Also, you may want to reset this login's
password to make sure you'll use correct password.
After this, you can retry to create an ODBC data source name for the Access
linking.
"Savas Ates" <savas@.indexinteractive.com> wrote in message
news:#w39Rq4NFHA.3336@.TK2MSFTNGP10.phx.gbl...
> my sql server is not in local network.. it is in remote network... and its
> ip , username and password is true...
> coz i can access it from enterprise manager from my local sql server...
> i looked at my permissions.. from users in my database ...
> in my dbo public and db_owner permit checked... what is tthe problem ?
>
>
> tried link to sql server db from access and i failed... (What is my
> fault.. I think It doenst ask me catalog -database name so it doesnt
accept
> my username and password..It cant find my username and password which
> database has it ..)
> i follewed these steps...
> 1.right click and link table
> 2.chooes types of data -->ODBC Databases
> 3.Machine(or Computer) Data Source and Click New from here..
> 4.Choose User Data Source and click NEXT
> 5.Chooes SQL Server and click NEXT
> 6.Click END
> 7.enter Server IP description and Name and click NEXT
> 8.Chooes Sql Server Authentication and Username and password of my
catalog
> database... and CLICK NEXT
> 9.SQL State='010000'
> Sql Server Failure:10060
> [microsoft [[ODBC SQL Server Driver][TCP/IP Sockets] ConnectionOpen
> (Connect())
> Connection failed
> Sql State: '08001'
> Sql Server Failure:17
> [microsoft [[ODBC SQL Server Driver][TCP/IP Sockets] Sql server doesnt
> exists or access denied..
> how can i solve it or can link a sql server database
>
>
|||i made what u said but there is not any tab database access .. There is
only general Tab...
what i must do ?
"Norman Yuan" <NotReal@.NotReal.not>, haber iletisinde unlar
yazd:uA6Iy86NFHA.3296@.TK2MSFTNGP15.phx.gbl...
> So, your Enterprise Manager is connected to this remove SQL Server. Then
> it
> is Step 8. it must be the username/password, which is an Login's
> authentication credential.
> In your EM, go to the "SQL Server->Security->Logins", right-click the
> login
> you are to use and select "Prooerties". Select tab "Database Access" and
> check one or more database you'd like this login to have access and set
> appropriate database roles. Also, you may want to reset this login's
> password to make sure you'll use correct password.
> After this, you can retry to create an ODBC data source name for the
> Access
> linking.
>
|||Are you sure you clicked correct object?
It is the node on left: Console Root->Microsoft SQL Server->SQL Server
Group->(server name)->Security->Logins".
On right, right click any Login listed and "Properties". The "Properties"
dialog has three tabs: "General", "Server Roles" and "Database Access".
If you did not see three tab, are you really using Enterprise Manager?, or
you right-clicked a user under database, which "Properties" dialog has only
"General" tab.
"Savas Ates" <savas@.indexinteractive.com> wrote in message
news:e#dQ0heOFHA.3808@.TK2MSFTNGP14.phx.gbl...
> i made what u said but there is not any tab database access .. There is
> only general Tab...
> what i must do ?
>
> "Norman Yuan" <NotReal@.NotReal.not>, haber iletisinde unlar
> yazd:uA6Iy86NFHA.3296@.TK2MSFTNGP15.phx.gbl...
>
|||my database is a remote one.. i right click other users i see only help
dialog..
i right click my user and i click and i can see properties dialog..i see
only general tab.. can it be due to my admin's settings.. what he and i must
do solve this problem... sure i user enteprrise manager by the way

when i open my database-->users--> on the right side i can see dbo... i
right click and chooes properties .. but i cant change my settings (i see
only general tab.. )
dont forget that my first attemp is not same with this.. i made what u said
truly...
by the way which roles or permission must be given my database ?
"Norman Yuan" <NotReal@.NotReal.not>, haber iletisinde unlar
yazd:uUF1Z1eOFHA.1528@.TK2MSFTNGP09.phx.gbl...
> Are you sure you clicked correct object?
> It is the node on left: Console Root->Microsoft SQL Server->SQL Server
> Group->(server name)->Security->Logins".
> On right, right click any Login listed and "Properties". The "Properties"
> dialog has three tabs: "General", "Server Roles" and "Database Access".
> If you did not see three tab, are you really using Enterprise Manager?, or
> you right-clicked a user under database, which "Properties" dialog has
> only
> "General" tab.
>

LINK SQL SERVER DATABASE FROM ACCESS

i tried link to sql server db from access and i failed... (What is my
fault.. I think It doenst ask me catalog -database name so it doesnt accept
my username and password..It cant find my username and password which
database has it ..)
i follewed these steps...
1.right click and link table
2.chooes types of data -->ODBC Databases
3.Machine(or Computer) Data Source and Click New from here..
4.Choose User Data Source and click NEXT
5.Chooes SQL Server and click NEXT
6.Click END
7.enter Server IP description and Name and click NEXT
8.Chooes Sql Server Authentication and Username and password of my catalog
database... and CLICK NEXT
9.SQL State='010000'
Sql Server Failure:10060
[microsoft [[ODBC SQL Server Driver][TCP/IP Sockets] ConnectionOpen
(Connect())
Connection failed
Sql State: '08001'
Sql Server Failure:17
[microsoft [[ODBC SQL Server Driver][TCP/IP Sockets] Sql server doesnt
exists or access denied..
how can i solve it or can link a sql server database
Problem lies in either step 7 or step 8.
Step 7: where is the SQL Server located? If it is on your local network,
simply enter "SeverName" or "ServerName\SQLInstanceName", If it is on an
WinXP Pro with SP2, does the TCP/IP port (1433) is allowed through the
firewall (if it is enabled).
If your are sure the network setup is correct, then it is Step 8: you did
not give correct login credential. SQL Server uses Win security (no need to
supply username/password) or SQL Security (you must supply username/pswd).
However, even your login credential is correct, it does not necessarily mean
that you can access a database on the SL Server. The administrator can give
or deny access to a database for a login (whether it is Win Security or SQL
Security). You may have check with the DB administrator to make sure the
login you use has access to the database.
"Savas Ates" <savas@.indexinteractive.com> wrote in message
news:OynZrvtNFHA.2704@.TK2MSFTNGP15.phx.gbl...
> i tried link to sql server db from access and i failed... (What is my
> fault.. I think It doenst ask me catalog -database name so it doesnt
accept
> my username and password..It cant find my username and password which
> database has it ..)
> i follewed these steps...
> 1.right click and link table
> 2.chooes types of data -->ODBC Databases
> 3.Machine(or Computer) Data Source and Click New from here..
> 4.Choose User Data Source and click NEXT
> 5.Chooes SQL Server and click NEXT
> 6.Click END
> 7.enter Server IP description and Name and click NEXT
> 8.Chooes Sql Server Authentication and Username and password of my
catalog
> database... and CLICK NEXT
> 9.SQL State='010000'
> Sql Server Failure:10060
> [microsoft [[ODBC SQL Server Driver][TCP/IP Sockets] ConnectionOpen
> (Connect())
> Connection failed
> Sql State: '08001'
> Sql Server Failure:17
> [microsoft [[ODBC SQL Server Driver][TCP/IP Sockets] Sql server doesnt
> exists or access denied..
> how can i solve it or can link a sql server database
>
>
>
|||my sql server is not in local network.. it is in remote network... and its
ip , username and password is true...
coz i can access it from enterprise manager from my local sql server...
i looked at my permissions.. from users in my database ...
in my dbo public and db_owner permit checked... what is tthe problem ?
tried link to sql server db from access and i failed... (What is my
fault.. I think It doenst ask me catalog -database name so it doesnt accept
my username and password..It cant find my username and password which
database has it ..)
i follewed these steps...
1.right click and link table
2.chooes types of data -->ODBC Databases
3.Machine(or Computer) Data Source and Click New from here..
4.Choose User Data Source and click NEXT
5.Chooes SQL Server and click NEXT
6.Click END
7.enter Server IP description and Name and click NEXT
8.Chooes Sql Server Authentication and Username and password of my catalog
database... and CLICK NEXT
9.SQL State='010000'
Sql Server Failure:10060
[microsoft [[ODBC SQL Server Driver][TCP/IP Sockets] ConnectionOpen
(Connect())
Connection failed
Sql State: '08001'
Sql Server Failure:17
[microsoft [[ODBC SQL Server Driver][TCP/IP Sockets] Sql server doesnt
exists or access denied..
how can i solve it or can link a sql server database
|||So, your Enterprise Manager is connected to this remove SQL Server. Then it
is Step 8. it must be the username/password, which is an Login's
authentication credential.
In your EM, go to the "SQL Server->Security->Logins", right-click the login
you are to use and select "Prooerties". Select tab "Database Access" and
check one or more database you'd like this login to have access and set
appropriate database roles. Also, you may want to reset this login's
password to make sure you'll use correct password.
After this, you can retry to create an ODBC data source name for the Access
linking.
"Savas Ates" <savas@.indexinteractive.com> wrote in message
news:#w39Rq4NFHA.3336@.TK2MSFTNGP10.phx.gbl...
> my sql server is not in local network.. it is in remote network... and its
> ip , username and password is true...
> coz i can access it from enterprise manager from my local sql server...
> i looked at my permissions.. from users in my database ...
> in my dbo public and db_owner permit checked... what is tthe problem ?
>
>
> tried link to sql server db from access and i failed... (What is my
> fault.. I think It doenst ask me catalog -database name so it doesnt
accept
> my username and password..It cant find my username and password which
> database has it ..)
> i follewed these steps...
> 1.right click and link table
> 2.chooes types of data -->ODBC Databases
> 3.Machine(or Computer) Data Source and Click New from here..
> 4.Choose User Data Source and click NEXT
> 5.Chooes SQL Server and click NEXT
> 6.Click END
> 7.enter Server IP description and Name and click NEXT
> 8.Chooes Sql Server Authentication and Username and password of my
catalog
> database... and CLICK NEXT
> 9.SQL State='010000'
> Sql Server Failure:10060
> [microsoft [[ODBC SQL Server Driver][TCP/IP Sockets] ConnectionOpen
> (Connect())
> Connection failed
> Sql State: '08001'
> Sql Server Failure:17
> [microsoft [[ODBC SQL Server Driver][TCP/IP Sockets] Sql server doesnt
> exists or access denied..
> how can i solve it or can link a sql server database
>
>
|||i made what u said but there is not any tab database access .. There is
only general Tab...
what i must do ?
"Norman Yuan" <NotReal@.NotReal.not>, haber iletisinde unlar
yazd:uA6Iy86NFHA.3296@.TK2MSFTNGP15.phx.gbl...
> So, your Enterprise Manager is connected to this remove SQL Server. Then
> it
> is Step 8. it must be the username/password, which is an Login's
> authentication credential.
> In your EM, go to the "SQL Server->Security->Logins", right-click the
> login
> you are to use and select "Prooerties". Select tab "Database Access" and
> check one or more database you'd like this login to have access and set
> appropriate database roles. Also, you may want to reset this login's
> password to make sure you'll use correct password.
> After this, you can retry to create an ODBC data source name for the
> Access
> linking.
>
|||Are you sure you clicked correct object?
It is the node on left: Console Root->Microsoft SQL Server->SQL Server
Group->(server name)->Security->Logins".
On right, right click any Login listed and "Properties". The "Properties"
dialog has three tabs: "General", "Server Roles" and "Database Access".
If you did not see three tab, are you really using Enterprise Manager?, or
you right-clicked a user under database, which "Properties" dialog has only
"General" tab.
"Savas Ates" <savas@.indexinteractive.com> wrote in message
news:e#dQ0heOFHA.3808@.TK2MSFTNGP14.phx.gbl...
> i made what u said but there is not any tab database access .. There is
> only general Tab...
> what i must do ?
>
> "Norman Yuan" <NotReal@.NotReal.not>, haber iletisinde unlar
> yazd:uA6Iy86NFHA.3296@.TK2MSFTNGP15.phx.gbl...
>
|||my database is a remote one.. i right click other users i see only help
dialog..
i right click my user and i click and i can see properties dialog..i see
only general tab.. can it be due to my admin's settings.. what he and i must
do solve this problem... sure i user enteprrise manager by the way

LINK SQL SERVER DATABASE FROM ACCESS

i tried link to sql server db from access and i failed... (What is my
fault.. I think It doenst ask me catalog -database name so it doesnt accept
my username and password..It cant find my username and password which
database has it ..)
i follewed these steps...
1.right click and link table
2.chooes types of data -->ODBC Databases
3.Machine(or Computer) Data Source and Click New from here..
4.Choose User Data Source and click NEXT
5.Chooes SQL Server and click NEXT
6.Click END
7.enter Server IP description and Name and click NEXT
8.Chooes Sql Server Authentication and Username and password of my catalog
database... and CLICK NEXT
9.SQL State='010000'
Sql Server Failure:10060
[microsoft [[ODBC SQL Server Driver][TCP/IP Sockets] ConnectionOpen
(Connect())
Connection failed
Sql State: '08001'
Sql Server Failure:17
[microsoft [[ODBC SQL Server Driver][TCP/IP Sockets] Sql server doesnt
exists or access denied..
how can i solve it or can link a sql server database
Problem lies in either step 7 or step 8.
Step 7: where is the SQL Server located? If it is on your local network,
simply enter "SeverName" or "ServerName\SQLInstanceName", If it is on an
WinXP Pro with SP2, does the TCP/IP port (1433) is allowed through the
firewall (if it is enabled).
If your are sure the network setup is correct, then it is Step 8: you did
not give correct login credential. SQL Server uses Win security (no need to
supply username/password) or SQL Security (you must supply username/pswd).
However, even your login credential is correct, it does not necessarily mean
that you can access a database on the SL Server. The administrator can give
or deny access to a database for a login (whether it is Win Security or SQL
Security). You may have check with the DB administrator to make sure the
login you use has access to the database.
"Savas Ates" <savas@.indexinteractive.com> wrote in message
news:OynZrvtNFHA.2704@.TK2MSFTNGP15.phx.gbl...
> i tried link to sql server db from access and i failed... (What is my
> fault.. I think It doenst ask me catalog -database name so it doesnt
accept
> my username and password..It cant find my username and password which
> database has it ..)
> i follewed these steps...
> 1.right click and link table
> 2.chooes types of data -->ODBC Databases
> 3.Machine(or Computer) Data Source and Click New from here..
> 4.Choose User Data Source and click NEXT
> 5.Chooes SQL Server and click NEXT
> 6.Click END
> 7.enter Server IP description and Name and click NEXT
> 8.Chooes Sql Server Authentication and Username and password of my
catalog
> database... and CLICK NEXT
> 9.SQL State='010000'
> Sql Server Failure:10060
> [microsoft [[ODBC SQL Server Driver][TCP/IP Sockets] ConnectionOpen
> (Connect())
> Connection failed
> Sql State: '08001'
> Sql Server Failure:17
> [microsoft [[ODBC SQL Server Driver][TCP/IP Sockets] Sql server doesnt
> exists or access denied..
> how can i solve it or can link a sql server database
>
>
>
|||my sql server is not in local network.. it is in remote network... and its
ip , username and password is true...
coz i can access it from enterprise manager from my local sql server...
i looked at my permissions.. from users in my database ...
in my dbo public and db_owner permit checked... what is tthe problem ?
tried link to sql server db from access and i failed... (What is my
fault.. I think It doenst ask me catalog -database name so it doesnt accept
my username and password..It cant find my username and password which
database has it ..)
i follewed these steps...
1.right click and link table
2.chooes types of data -->ODBC Databases
3.Machine(or Computer) Data Source and Click New from here..
4.Choose User Data Source and click NEXT
5.Chooes SQL Server and click NEXT
6.Click END
7.enter Server IP description and Name and click NEXT
8.Chooes Sql Server Authentication and Username and password of my catalog
database... and CLICK NEXT
9.SQL State='010000'
Sql Server Failure:10060
[microsoft [[ODBC SQL Server Driver][TCP/IP Sockets] ConnectionOpen
(Connect())
Connection failed
Sql State: '08001'
Sql Server Failure:17
[microsoft [[ODBC SQL Server Driver][TCP/IP Sockets] Sql server doesnt
exists or access denied..
how can i solve it or can link a sql server database
|||So, your Enterprise Manager is connected to this remove SQL Server. Then it
is Step 8. it must be the username/password, which is an Login's
authentication credential.
In your EM, go to the "SQL Server->Security->Logins", right-click the login
you are to use and select "Prooerties". Select tab "Database Access" and
check one or more database you'd like this login to have access and set
appropriate database roles. Also, you may want to reset this login's
password to make sure you'll use correct password.
After this, you can retry to create an ODBC data source name for the Access
linking.
"Savas Ates" <savas@.indexinteractive.com> wrote in message
news:#w39Rq4NFHA.3336@.TK2MSFTNGP10.phx.gbl...
> my sql server is not in local network.. it is in remote network... and its
> ip , username and password is true...
> coz i can access it from enterprise manager from my local sql server...
> i looked at my permissions.. from users in my database ...
> in my dbo public and db_owner permit checked... what is tthe problem ?
>
>
> tried link to sql server db from access and i failed... (What is my
> fault.. I think It doenst ask me catalog -database name so it doesnt
accept
> my username and password..It cant find my username and password which
> database has it ..)
> i follewed these steps...
> 1.right click and link table
> 2.chooes types of data -->ODBC Databases
> 3.Machine(or Computer) Data Source and Click New from here..
> 4.Choose User Data Source and click NEXT
> 5.Chooes SQL Server and click NEXT
> 6.Click END
> 7.enter Server IP description and Name and click NEXT
> 8.Chooes Sql Server Authentication and Username and password of my
catalog
> database... and CLICK NEXT
> 9.SQL State='010000'
> Sql Server Failure:10060
> [microsoft [[ODBC SQL Server Driver][TCP/IP Sockets] ConnectionOpen
> (Connect())
> Connection failed
> Sql State: '08001'
> Sql Server Failure:17
> [microsoft [[ODBC SQL Server Driver][TCP/IP Sockets] Sql server doesnt
> exists or access denied..
> how can i solve it or can link a sql server database
>
>
|||i made what u said but there is not any tab database access .. There is
only general Tab...
what i must do ?
"Norman Yuan" <NotReal@.NotReal.not>, haber iletisinde unlar
yazd:uA6Iy86NFHA.3296@.TK2MSFTNGP15.phx.gbl...
> So, your Enterprise Manager is connected to this remove SQL Server. Then
> it
> is Step 8. it must be the username/password, which is an Login's
> authentication credential.
> In your EM, go to the "SQL Server->Security->Logins", right-click the
> login
> you are to use and select "Prooerties". Select tab "Database Access" and
> check one or more database you'd like this login to have access and set
> appropriate database roles. Also, you may want to reset this login's
> password to make sure you'll use correct password.
> After this, you can retry to create an ODBC data source name for the
> Access
> linking.
>
|||Are you sure you clicked correct object?
It is the node on left: Console Root->Microsoft SQL Server->SQL Server
Group->(server name)->Security->Logins".
On right, right click any Login listed and "Properties". The "Properties"
dialog has three tabs: "General", "Server Roles" and "Database Access".
If you did not see three tab, are you really using Enterprise Manager?, or
you right-clicked a user under database, which "Properties" dialog has only
"General" tab.
"Savas Ates" <savas@.indexinteractive.com> wrote in message
news:e#dQ0heOFHA.3808@.TK2MSFTNGP14.phx.gbl...
> i made what u said but there is not any tab database access .. There is
> only general Tab...
> what i must do ?
>
> "Norman Yuan" <NotReal@.NotReal.not>, haber iletisinde unlar
> yazd:uA6Iy86NFHA.3296@.TK2MSFTNGP15.phx.gbl...
>
|||my database is a remote one.. i right click other users i see only help
dialog..
i right click my user and i click and i can see properties dialog..i see
only general tab.. can it be due to my admin's settings.. what he and i must
do solve this problem... sure i user enteprrise manager by the way

LINK SQL SERVER DATABASE FROM ACCESS

i tried link to sql server db from access and i failed... (What is my
fault.. I think It doenst ask me catalog -database name so it doesnt accept
my username and password..It cant find my username and password which
database has it ..)
i follewed these steps...
1.right click and link table
2.chooes types of data -->ODBC Databases
3.Machine(or Computer) Data Source and Click New from here..
4.Choose User Data Source and click NEXT
5.Chooes SQL Server and click NEXT
6.Click END
7.enter Server IP description and Name and click NEXT
8.Chooes Sql Server Authentication and Username and password of my catalog
database... and CLICK NEXT
9.SQL State='010000'
Sql Server Failure:10060
[microsoft [[ODBC SQL Server Driver][TCP/IP Sockets] ConnectionOpen
(Connect())
Connection failed
Sql State: '08001'
Sql Server Failure:17
[microsoft [[ODBC SQL Server Driver][TCP/IP Sockets] Sql server doesnt
exists or access denied..
how can i solve it or can link a sql server databaseProblem lies in either step 7 or step 8.
Step 7: where is the SQL Server located? If it is on your local network,
simply enter "SeverName" or "ServerName\SQLInstanceName", If it is on an
WinXP Pro with SP2, does the TCP/IP port (1433) is allowed through the
firewall (if it is enabled).
If your are sure the network setup is correct, then it is Step 8: you did
not give correct login credential. SQL Server uses Win security (no need to
supply username/password) or SQL Security (you must supply username/pswd).
However, even your login credential is correct, it does not necessarily mean
that you can access a database on the SL Server. The administrator can give
or deny access to a database for a login (whether it is Win Security or SQL
Security). You may have check with the DB administrator to make sure the
login you use has access to the database.
"Savas Ates" <savas@.indexinteractive.com> wrote in message
news:OynZrvtNFHA.2704@.TK2MSFTNGP15.phx.gbl...
> i tried link to sql server db from access and i failed... (What is my
> fault.. I think It doenst ask me catalog -database name so it doesnt
accept
> my username and password..It cant find my username and password which
> database has it ..)
> i follewed these steps...
> 1.right click and link table
> 2.chooes types of data -->ODBC Databases
> 3.Machine(or Computer) Data Source and Click New from here..
> 4.Choose User Data Source and click NEXT
> 5.Chooes SQL Server and click NEXT
> 6.Click END
> 7.enter Server IP description and Name and click NEXT
> 8.Chooes Sql Server Authentication and Username and password of my
catalog
> database... and CLICK NEXT
> 9.SQL State='010000'
> Sql Server Failure:10060
> [microsoft [[ODBC SQL Server Driver][TCP/IP Sockets] ConnectionOpen
> (Connect())
> Connection failed
> Sql State: '08001'
> Sql Server Failure:17
> [microsoft [[ODBC SQL Server Driver][TCP/IP Sockets] Sql server doesnt
> exists or access denied..
> how can i solve it or can link a sql server database
>
>
>|||my sql server is not in local network.. it is in remote network... and its
ip , username and password is true...
coz i can access it from enterprise manager from my local sql server...
i looked at my permissions.. from users in my database ...
in my dbo public and db_owner permit checked... what is tthe problem ?
tried link to sql server db from access and i failed... (What is my
fault.. I think It doenst ask me catalog -database name so it doesnt accept
my username and password..It cant find my username and password which
database has it ..)
i follewed these steps...
1.right click and link table
2.chooes types of data -->ODBC Databases
3.Machine(or Computer) Data Source and Click New from here..
4.Choose User Data Source and click NEXT
5.Chooes SQL Server and click NEXT
6.Click END
7.enter Server IP description and Name and click NEXT
8.Chooes Sql Server Authentication and Username and password of my catalog
database... and CLICK NEXT
9.SQL State='010000'
Sql Server Failure:10060
[microsoft [[ODBC SQL Server Driver][TCP/IP Sockets] ConnectionOpen
(Connect())
Connection failed
Sql State: '08001'
Sql Server Failure:17
[microsoft [[ODBC SQL Server Driver][TCP/IP Sockets] Sql server doesnt
exists or access denied..
how can i solve it or can link a sql server database|||So, your Enterprise Manager is connected to this remove SQL Server. Then it
is Step 8. it must be the username/password, which is an Login's
authentication credential.
In your EM, go to the "SQL Server->Security->Logins", right-click the login
you are to use and select "Prooerties". Select tab "Database Access" and
check one or more database you'd like this login to have access and set
appropriate database roles. Also, you may want to reset this login's
password to make sure you'll use correct password.
After this, you can retry to create an ODBC data source name for the Access
linking.
"Savas Ates" <savas@.indexinteractive.com> wrote in message
news:#w39Rq4NFHA.3336@.TK2MSFTNGP10.phx.gbl...
> my sql server is not in local network.. it is in remote network... and its
> ip , username and password is true...
> coz i can access it from enterprise manager from my local sql server...
> i looked at my permissions.. from users in my database ...
> in my dbo public and db_owner permit checked... what is tthe problem ?
>
>
> tried link to sql server db from access and i failed... (What is my
> fault.. I think It doenst ask me catalog -database name so it doesnt
accept
> my username and password..It cant find my username and password which
> database has it ..)
> i follewed these steps...
> 1.right click and link table
> 2.chooes types of data -->ODBC Databases
> 3.Machine(or Computer) Data Source and Click New from here..
> 4.Choose User Data Source and click NEXT
> 5.Chooes SQL Server and click NEXT
> 6.Click END
> 7.enter Server IP description and Name and click NEXT
> 8.Chooes Sql Server Authentication and Username and password of my
catalog
> database... and CLICK NEXT
> 9.SQL State='010000'
> Sql Server Failure:10060
> [microsoft [[ODBC SQL Server Driver][TCP/IP Sockets] ConnectionOpen
> (Connect())
> Connection failed
> Sql State: '08001'
> Sql Server Failure:17
> [microsoft [[ODBC SQL Server Driver][TCP/IP Sockets] Sql server doesnt
> exists or access denied..
> how can i solve it or can link a sql server database
>
>|||i made what u said but there is not any tab database access .. There is
only general Tab...
what i must do ?
"Norman Yuan" <NotReal@.NotReal.not>, haber iletisinde þunlarý
yazdý:uA6Iy86NFHA.3296@.TK2MSFTNGP15.phx.gbl...
> So, your Enterprise Manager is connected to this remove SQL Server. Then
> it
> is Step 8. it must be the username/password, which is an Login's
> authentication credential.
> In your EM, go to the "SQL Server->Security->Logins", right-click the
> login
> you are to use and select "Prooerties". Select tab "Database Access" and
> check one or more database you'd like this login to have access and set
> appropriate database roles. Also, you may want to reset this login's
> password to make sure you'll use correct password.
> After this, you can retry to create an ODBC data source name for the
> Access
> linking.
>|||Are you sure you clicked correct object?
It is the node on left: Console Root->Microsoft SQL Server->SQL Server
Group->(server name)->Security->Logins".
On right, right click any Login listed and "Properties". The "Properties"
dialog has three tabs: "General", "Server Roles" and "Database Access".
If you did not see three tab, are you really using Enterprise Manager?, or
you right-clicked a user under database, which "Properties" dialog has only
"General" tab.
"Savas Ates" <savas@.indexinteractive.com> wrote in message
news:e#dQ0heOFHA.3808@.TK2MSFTNGP14.phx.gbl...
> i made what u said but there is not any tab database access .. There is
> only general Tab...
> what i must do ?
>
> "Norman Yuan" <NotReal@.NotReal.not>, haber iletisinde þunlarý
> yazdý:uA6Iy86NFHA.3296@.TK2MSFTNGP15.phx.gbl...
> > So, your Enterprise Manager is connected to this remove SQL Server. Then
> > it
> > is Step 8. it must be the username/password, which is an Login's
> > authentication credential.
> >
> > In your EM, go to the "SQL Server->Security->Logins", right-click the
> > login
> > you are to use and select "Prooerties". Select tab "Database Access" and
> > check one or more database you'd like this login to have access and set
> > appropriate database roles. Also, you may want to reset this login's
> > password to make sure you'll use correct password.
> >
> > After this, you can retry to create an ODBC data source name for the
> > Access
> > linking.
> >
>|||my database is a remote one.. i right click other users i see only help
dialog..
i right click my user and i click and i can see properties dialog..i see
only general tab.. can it be due to my admin's settings.. what he and i must
do solve this problem... sure i user enteprrise manager by the way :)
when i open my database-->users--> on the right side i can see dbo... i
right click and chooes properties .. but i cant change my settings (i see
only general tab.. )
dont forget that my first attemp is not same with this.. i made what u said
truly...
by the way which roles or permission must be given my database ?
"Norman Yuan" <NotReal@.NotReal.not>, haber iletisinde þunlarý
yazdý:uUF1Z1eOFHA.1528@.TK2MSFTNGP09.phx.gbl...
> Are you sure you clicked correct object?
> It is the node on left: Console Root->Microsoft SQL Server->SQL Server
> Group->(server name)->Security->Logins".
> On right, right click any Login listed and "Properties". The "Properties"
> dialog has three tabs: "General", "Server Roles" and "Database Access".
> If you did not see three tab, are you really using Enterprise Manager?, or
> you right-clicked a user under database, which "Properties" dialog has
> only
> "General" tab.
>

LINK SQL SERVER DATABASE FROM ACCESS

i tried link to sql server db from access and i failed... (What is my
fault.. I think It doenst ask me catalog -database name so it doesnt accept
my username and password..It cant find my username and password which
database has it ..)
i follewed these steps...
1.right click and link table
2.chooes types of data -->ODBC Databases
3.Machine(or Computer) Data Source and Click New from here..
4.Choose User Data Source and click NEXT
5.Chooes SQL Server and click NEXT
6.Click END
7.enter Server IP description and Name and click NEXT
8.Chooes Sql Server Authentication and Username and password of my catalog
database... and CLICK NEXT
9.SQL State='010000'
Sql Server Failure:10060
[microsoft [[ODBC SQL Server Driver][TCP/IP Sockets] Connect
ionOpen
(Connect())
Connection failed
Sql State: '08001'
Sql Server Failure:17
[microsoft [[ODBC SQL Server Driver][TCP/IP Sockets] Sql ser
ver doesnt
exists or access denied..
how can i solve it or can link a sql server databaseProblem lies in either step 7 or step 8.
Step 7: where is the SQL Server located? If it is on your local network,
simply enter "SeverName" or "ServerName\SQLInstanceName", If it is on an
WinXP Pro with SP2, does the TCP/IP port (1433) is allowed through the
firewall (if it is enabled).
If your are sure the network setup is correct, then it is Step 8: you did
not give correct login credential. SQL Server uses Win security (no need to
supply username/password) or SQL Security (you must supply username/pswd).
However, even your login credential is correct, it does not necessarily mean
that you can access a database on the SL Server. The administrator can give
or deny access to a database for a login (whether it is Win Security or SQL
Security). You may have check with the DB administrator to make sure the
login you use has access to the database.
"Savas Ates" <savas@.indexinteractive.com> wrote in message
news:OynZrvtNFHA.2704@.TK2MSFTNGP15.phx.gbl...
> i tried link to sql server db from access and i failed... (What is my
> fault.. I think It doenst ask me catalog -database name so it doesnt
accept
> my username and password..It cant find my username and password which
> database has it ..)
> i follewed these steps...
> 1.right click and link table
> 2.chooes types of data -->ODBC Databases
> 3.Machine(or Computer) Data Source and Click New from here..
> 4.Choose User Data Source and click NEXT
> 5.Chooes SQL Server and click NEXT
> 6.Click END
> 7.enter Server IP description and Name and click NEXT
> 8.Chooes Sql Server Authentication and Username and password of my
catalog
> database... and CLICK NEXT
> 9.SQL State='010000'
> Sql Server Failure:10060
> [microsoft [[ODBC SQL Server Driver][TCP/IP Sockets] Conne
ctionOpen
> (Connect())
> Connection failed
> Sql State: '08001'
> Sql Server Failure:17
> [microsoft [[ODBC SQL Server Driver][TCP/IP Sockets] Sql s
erver doesnt
> exists or access denied..
> how can i solve it or can link a sql server database
>
>
>|||my sql server is not in local network.. it is in remote network... and its
ip , username and password is true...
coz i can access it from enterprise manager from my local sql server...
i looked at my permissions.. from users in my database ...
in my dbo public and db_owner permit checked... what is tthe problem ?
tried link to sql server db from access and i failed... (What is my
fault.. I think It doenst ask me catalog -database name so it doesnt accept
my username and password..It cant find my username and password which
database has it ..)
i follewed these steps...
1.right click and link table
2.chooes types of data -->ODBC Databases
3.Machine(or Computer) Data Source and Click New from here..
4.Choose User Data Source and click NEXT
5.Chooes SQL Server and click NEXT
6.Click END
7.enter Server IP description and Name and click NEXT
8.Chooes Sql Server Authentication and Username and password of my catalog
database... and CLICK NEXT
9.SQL State='010000'
Sql Server Failure:10060
[microsoft [[ODBC SQL Server Driver][TCP/IP Sockets] Connect
ionOpen
(Connect())
Connection failed
Sql State: '08001'
Sql Server Failure:17
[microsoft [[ODBC SQL Server Driver][TCP/IP Sockets] Sql ser
ver doesnt
exists or access denied..
how can i solve it or can link a sql server database|||So, your Enterprise Manager is connected to this remove SQL Server. Then it
is Step 8. it must be the username/password, which is an Login's
authentication credential.
In your EM, go to the "SQL Server->Security->Logins", right-click the login
you are to use and select "Prooerties". Select tab "Database Access" and
check one or more database you'd like this login to have access and set
appropriate database roles. Also, you may want to reset this login's
password to make sure you'll use correct password.
After this, you can retry to create an ODBC data source name for the Access
linking.
"Savas Ates" <savas@.indexinteractive.com> wrote in message
news:#w39Rq4NFHA.3336@.TK2MSFTNGP10.phx.gbl...
> my sql server is not in local network.. it is in remote network... and its
> ip , username and password is true...
> coz i can access it from enterprise manager from my local sql server...
> i looked at my permissions.. from users in my database ...
> in my dbo public and db_owner permit checked... what is tthe problem ?
>
>
> tried link to sql server db from access and i failed... (What is my
> fault.. I think It doenst ask me catalog -database name so it doesnt
accept
> my username and password..It cant find my username and password which
> database has it ..)
> i follewed these steps...
> 1.right click and link table
> 2.chooes types of data -->ODBC Databases
> 3.Machine(or Computer) Data Source and Click New from here..
> 4.Choose User Data Source and click NEXT
> 5.Chooes SQL Server and click NEXT
> 6.Click END
> 7.enter Server IP description and Name and click NEXT
> 8.Chooes Sql Server Authentication and Username and password of my
catalog
> database... and CLICK NEXT
> 9.SQL State='010000'
> Sql Server Failure:10060
> [microsoft [[ODBC SQL Server Driver][TCP/IP Sockets] Conne
ctionOpen
> (Connect())
> Connection failed
> Sql State: '08001'
> Sql Server Failure:17
> [microsoft [[ODBC SQL Server Driver][TCP/IP Sockets] Sql s
erver doesnt
> exists or access denied..
> how can i solve it or can link a sql server database
>
>|||i made what u said but there is not any tab database access .. There is
only general Tab...
what i must do ?
"Norman Yuan" <NotReal@.NotReal.not>, haber iletisinde unlar
yazd:uA6Iy86NFHA.3296@.TK2MSFTNGP15.phx.gbl...
> So, your Enterprise Manager is connected to this remove SQL Server. Then
> it
> is Step 8. it must be the username/password, which is an Login's
> authentication credential.
> In your EM, go to the "SQL Server->Security->Logins", right-click the
> login
> you are to use and select "Prooerties". Select tab "Database Access" and
> check one or more database you'd like this login to have access and set
> appropriate database roles. Also, you may want to reset this login's
> password to make sure you'll use correct password.
> After this, you can retry to create an ODBC data source name for the
> Access
> linking.
>|||Are you sure you clicked correct object?
It is the node on left: Console Root->Microsoft SQL Server->SQL Server
Group->(server name)->Security->Logins".
On right, right click any Login listed and "Properties". The "Properties"
dialog has three tabs: "General", "Server Roles" and "Database Access".
If you did not see three tab, are you really using Enterprise Manager?, or
you right-clicked a user under database, which "Properties" dialog has only
"General" tab.
"Savas Ates" <savas@.indexinteractive.com> wrote in message
news:e#dQ0heOFHA.3808@.TK2MSFTNGP14.phx.gbl...
> i made what u said but there is not any tab database access .. There is
> only general Tab...
> what i must do ?
>
> "Norman Yuan" <NotReal@.NotReal.not>, haber iletisinde unlar
> yazd:uA6Iy86NFHA.3296@.TK2MSFTNGP15.phx.gbl...
>|||my database is a remote one.. i right click other users i see only help
dialog..
i right click my user and i click and i can see properties dialog..i see
only general tab.. can it be due to my admin's settings.. what he and i must
do solve this problem... sure i user enteprrise manager by the way

Monday, March 26, 2012

Link server not working thru Windows authentication - "Login failed

I've two SQL server 2005 servers running under the same domain and the
SQL server service is also running under domain adminstrator for both
the servers. The OS on both the servers is Win2K3.
All the developers were working on these servers as 'sa' but recently
we have changed it to run on windows authentications. In doing so I
added all the developer's domain logins to a local group "Power Users"
on both the servers and now every body can log on to these servers
using their domain logins(windows authentication). But the link server
from serv1 to serv2 is giving error "Msg 18456, Level 14, State 1,
Line 1" "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'." if I
run a distributed querry from QA.
I've also tried adding individual logins on the Security tab on link
server gui and checked impersonate check box also but with no results.
On both the servers "NT AUTHORITY\NETWORK SERVICE" account exists with
sysadmin as server role.
One strange thing is if I directly logon (using my login) to the serv1
and run a distributed querry using the same link server it works.
Any help will be appriciated
Thanks,
SGsaboo,
I believe that you have a delegation problem here. Is Kerberos running in
your domain and are both servers correctly set up to user Kerboros? Read
this for an explanation:
http://blogs.msdn.com/sql_protocols/archive/2006/08/10/694657.aspx
When you directly login to serv1 you are now only one hop away from serv2
and delegation is not an issue. But, from a desktop to serv2 is two hops.
RLF
"saboo" <subodh97@.gmail.com> wrote in message
news:c210f136-752a-445a-94cf-b05599286972@.j20g2000hsi.googlegroups.com...
> I've two SQL server 2005 servers running under the same domain and the
> SQL server service is also running under domain adminstrator for both
> the servers. The OS on both the servers is Win2K3.
> All the developers were working on these servers as 'sa' but recently
> we have changed it to run on windows authentications. In doing so I
> added all the developer's domain logins to a local group "Power Users"
> on both the servers and now every body can log on to these servers
> using their domain logins(windows authentication). But the link server
> from serv1 to serv2 is giving error "Msg 18456, Level 14, State 1,
> Line 1" "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'." if I
> run a distributed querry from QA.
> I've also tried adding individual logins on the Security tab on link
> server gui and checked impersonate check box also but with no results.
> On both the servers "NT AUTHORITY\NETWORK SERVICE" account exists with
> sysadmin as server role.
> One strange thing is if I directly logon (using my login) to the serv1
> and run a distributed querry using the same link server it works.
> Any help will be appriciated
> Thanks,
> SG|||On Feb 13, 2:40=A0pm, "Russell Fields" <russellfie...@.nomail.com> wrote:
> saboo,
> I believe that you have a delegation problem here. =A0Is Kerberos running =in
> your domain and are both servers correctly set up to user Kerboros? =A0Rea=d
> this for an explanation:http://blogs.msdn.com/sql_protocols/archive/2006/0=
8/10/694657.aspx
> When you directly login to serv1 you are now only one hop away from serv2
> and delegation is not an issue. =A0But, from a desktop to serv2 is two hop=s.
> RLF
> "saboo" <subod...@.gmail.com> wrote in message
> news:c210f136-752a-445a-94cf-b05599286972@.j20g2000hsi.googlegroups.com...
>
> > I've two SQL server 2005 servers running under the same domain and the
> > SQL server service is also running under domain adminstrator for both
> > the servers. The OS on both the servers is Win2K3.
> > All the developers were working on these servers as 'sa' but recently
> > we have changed it to run on windows authentications. In doing so I
> > added all the developer's domain logins to a local group "Power Users"
> > on both the servers and now every body can log on to these servers
> > using their domain logins(windows authentication). But the link server
> > from serv1 to serv2 is giving error "Msg 18456, Level 14, State 1,
> > Line 1" "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'." if I
> > run a distributed querry from QA.
> > I've also tried adding individual logins on the Security tab on link
> > server gui and checked impersonate check box also but with no results.
> > On both the servers "NT AUTHORITY\NETWORK SERVICE" account exists with
> > sysadmin as server role.
> > One strange thing is if I directly logon (using my login) to the serv1
> > and run a distributed querry using the same link server it works.
> > Any help will be appriciated
> > Thanks,
> > SG- Hide quoted text -
> - Show quoted text -
Delegation isn't too bad to deal with. Most likely your SQL servers
are not using a Local Service account to run (good for you, this is
not good security) and the accounts it's using are not domain admins
(again, good job). Here's the quick down-low on what you need to do:
You need domain admin rights to create an SPN, if you don't have them
you need to get your DA to do this for you. Download the Windows
Server tools for your flavor of server(http://go.microsoft.com/fwlink/?
LinkId=3D100114). You want the SetSPN tool. You need to create an SPN
for each of the SQL servers, this can be done from your workstation as
it's set Domain wide, not at the server level.
setspn -a service/name hostname
i.e.
setspn -a MSSQLsvc/my.server.name:1433 mydomain\MySqlServiceAccount
Again, do this for BOTH sql servers...sql

Wednesday, March 28, 2012

LINK SQL SERVER DATABASE FROM ACCESS

LINK SQL SERVER DATABASE FROM ACCESS

LINK SQL SERVER DATABASE FROM ACCESS

LINK SQL SERVER DATABASE FROM ACCESS

LINK SQL SERVER DATABASE FROM ACCESS

LINK SQL SERVER DATABASE FROM ACCESS

Monday, March 26, 2012

Link server not working thru Windows authentication - "Login failed

LIMIT problems

Blog Archive

About Me