连接到SQL Server的访问权限 [英] Connect Access to SQL Server
问题描述
我是一个新的SQL Server用户，我的初始麻烦是将我的Access前端连接到后端的SQL Server表。我在计算机上通过ODBC完成没有问题，但在其他用户机器上我收到此错误：
SQL状态28000
SQL Server错误18456
登录失败
我的机器与它们的唯一不同之处在于我有SQL Server Management Suite，并且它们没有加载SQL Server软件我以为他们不需要安装任何东西。我做错了什么？
Robin
Hi,
I''m a new SQL Server user, and am having initial troule connecting my Access front end to my SQL Server tables in the back end. I have no problem doing it through ODBC on my computer, but on other users machines I get this error:
SQL State 28000
SQL Server error 18456
login failed
The only different between my machine and their''s is that I have SQL Server Management Suite, and they have no SQL Server software loaded in. I assumed that they didn''t need anything installed. What am I doing wrong?
Robin
推荐答案
我是新的SQL Server用户，并且我的初始麻烦是将我的Access前端连接到后端的SQL Server表。我在计算机上通过ODBC完成没有问题，但在其他用户机器上我收到此错误：
SQL状态28000
SQL Server错误18456
登录失败
我的机器与它们的唯一不同之处在于我有SQL Server Management Suite，并且它们没有加载SQL Server软件我以为他们不需要安装任何东西。我做错了什么？
Robin
Hi,
I''m a new SQL Server user, and am having initial troule connecting my Access front end to my SQL Server tables in the back end. I have no problem doing it through ODBC on my computer, but on other users machines I get this error:
SQL State 28000
SQL Server error 18456
login failed
The only different between my machine and their''s is that I have SQL Server Management Suite, and they have no SQL Server software loaded in. I assumed that they didn''t need anything installed. What am I doing wrong?
Robin
尝试检查sql连接的设置。如果你在sql server所在的同一台机器上开发，有时服务器名称是（local）。部署应用程序后无法正常工作...如果您使用的是odbc，则可能需要在安装它的每台计算机上创建一个odbc连接...尝试在创建后测试odbc的连接确保你正确配置...
- ck
try checking the setting of your sql connection. if you''re developing in the same machine that you''re sql server is, sometimes the server name is "(local)". that will not work once you deploy your application...if you''re using odbc, you might need to create an odbc connection on each machine that you install it to...try to test the connection of your odbc after creating to make sure you configured it properly...
-- ck
你好，
我是一个新的SQL Server用户，我的初始麻烦是将我的Access前端连接到后端的SQL Server表。我在计算机上通过ODBC完成没有问题，但在其他用户机器上我收到此错误：
SQL状态28000
SQL Server错误18456
登录失败
我的机器与它们的唯一不同之处在于我有SQL Server Management Suite，并且它们没有加载SQL Server软件我以为他们不需要安装任何东西。我做错了什么？
Robin
Hi,
I''m a new SQL Server user, and am having initial troule connecting my Access front end to my SQL Server tables in the back end. I have no problem doing it through ODBC on my computer, but on other users machines I get this error:
SQL State 28000
SQL Server error 18456
login failed
The only different between my machine and their''s is that I have SQL Server Management Suite, and they have no SQL Server software loaded in. I assumed that they didn''t need anything installed. What am I doing wrong?
Robin
嗨Rag，
我在这里有一些例程（如果你愿意，这是一个简单的策略）如果他们在访问前端不存在于机器上，则在代码中创建你的odbc。即当你的主表单打开一个简单的复选标记来表示（odbc ready，类似的东西），这样如果复选标记出现未标记，你就会知道例程失败了，并且odbc驱动程序不在他们的机器上那种东西）。你好吗？ windows集成安全性？您是否看过使用ADP文件（或者您的应用程序是在mdb中完全开发的）ADP'他们不使用odbc而是在（udl）通用数据链接下执行，该数据链接集成到adp（访问数据项目接口）中直接对SQL服务器说话
Jim：）
Hi Rag,
I have some routines here (a simple strategy if you like) to create your odbc in code if they don''t exist on the machine from the access frontend. ie when your main form opens a simple checkmark to denote (odbc ready, something like that) so that if the checkmark come up as unticked you''d know the routine failed and that odbc drivers not on their machine kind of thing). How are you connecting? windows integrated security? Have you looked at using ADP files (or is your app fully developed in mdb) ADP''s they don''t use odbc instead they perform under (udl) universal datalink which is integrated into the adp (access data project interface) for speaking directly to SQL server
Jim :)
感谢您的提示。我一直在考虑使用ADP，但还没有达到这一点，也许现在是时候了。
我通过ODBC连接，使用SQL Server身份验证和登录ID。我在我的计算机和用户上使用相同的登录名，我可以访问，我可以访问。服务器不是本地的，而是在我们的内部网上。
内部技术支持说我应该将SQL连接字符串嵌入到我的前端。你认为他们的意思是使用ADODB吗？
谢谢
Thanks for the tips. I''ve been thinking about using an ADP, but hadn''t gotten to that point yet, maybe this is time to do so.
I''m connecting through ODBC, using SQL Server authentication and a login ID. I use the same login on my computer and a users, and on mine I can access, on theirs I cannot. The server is not local, but on our intranet.
Internal tech support said I should embed the SQL connection string into my front end. Do you think they mean using ADODB?
Thanks
嗨Rag，
我在这里有一些例程（如果你愿意，这是一个简单的策略）如果它们不存在于访问前端的机器上，则在代码中创建你的odbc。即当你的主表单打开一个简单的复选标记来表示（odbc ready，类似的东西），这样如果复选标记出现未标记，你就会知道例程失败了，并且odbc驱动程序不在他们的机器上那种东西）。你好吗？ windows集成安全性？您是否看过使用ADP文件（或者您的应用程序是在mdb中完全开发的）ADP'他们不使用odbc而是在（udl）通用数据链接下执行，该数据链接集成到adp（访问数据项目接口）中直接对SQL服务器说话
吉姆:)
Hi Rag,
I have some routines here (a simple strategy if you like) to create your odbc in code if they don''t exist on the machine from the access frontend. ie when your main form opens a simple checkmark to denote (odbc ready, something like that) so that if the checkmark come up as unticked you''d know the routine failed and that odbc drivers not on their machine kind of thing). How are you connecting? windows integrated security? Have you looked at using ADP files (or is your app fully developed in mdb) ADP''s they don''t use odbc instead they perform under (udl) universal datalink which is integrated into the adp (access data project interface) for speaking directly to SQL server
Jim :)
这篇关于连接到SQL Server的访问权限的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
