我想连接到没有互联网的数据库，即窗口authientication [英] I want to connect to database without internet i.e window authientication

问题描述

我现在通过大学数据库连接多次关闭，我们必须坐下来，直到服务器再次启动。



现在我通过登录数据库引擎



登录：sa

密码：dbase



但我想离线连接甚至想要离开这个过程并想要使用窗口认证。



我尝试过：



我尝试了Windows身份验证但失败了。

I am now connecting through university database with many times shutdowns and we have to sit back until the server starts again.

Now i am Login to database engine through

Login: sa
Password: dbase

But i wanna offline connection or even wanna leave this process and want to use window authentication.

What I have tried:

I tried Windows Authentication but failed.

推荐答案

你不能。

SQL Server是服务器基于数据库管理系统 - 当您尝试使用数据库时，它需要运行并可访问服务器。如果缺少连接，则根本无法访问数据库，因为您必须通过SQL Server。 Windows身份验证对此没有帮助 - 即使服务器启动并运行它也可能无法正常工作。



有很多方法可以使用数据库不需要SQL Server，但它们几乎是使用本地计算机上的数据库而不是可由同学共享的数据库的单用户系统。对于这种工作，请查看SqLite，Access，甚至是SQLCE。或者，您可以在本地计算机上安装SQL Server的副本并使用它，然后在可用时更新远程数据库。更新部分可能会变得非常复杂，因此需要仔细考虑。 MS为这种开发提供了SQL Server Express，可以免费使用。

You can't.
SQL Server is a server based database management system - it requires a server to be running and accessible when you try to use the DB. If the connection is missing, you cannot access the DB at all, because you have to go via SQL server. Windows Authentication won't help that - and it's probably not going to work even when the server is up and running.

There are ways you can use a database that don't require SQL Server, but they pretty much are single user systems using a database on your local machine instead of one that can be shared by your fellow students. For this kind of work, look at SqLite, Access, or even SQLCE. Or, you could install a copy of SQL Server on your local computer and use that instead, then "update" the remote DB when it is available. The update part can get extremely complicated though, so it will need some careful thought. MS provide SQL Server Express for this kind of development, which is free to use.

这篇关于我想连接到没有互联网的数据库，即窗口authientication的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！