本文介绍了连接到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连接的设置。如果你在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




嗨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 :)



这篇关于连接到SQL Server的访问权限的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!

08-13 23:20