Hi,
I have a ASP.net 2.0 web app which i want to run on IIS. It has a database file stored in APP_DATA folder. I have set "UserInstance" property to False, as want to access the same database file from another app, which can do its own modification. So basically i want the same database to be shared. Now after putting the web app on IIS i am getting error like :
Login failed for user ''. The user is not associated with a trusted SQL Server connection.
Any idea of how to solve this?
Hello, I have created one application in visual studio 2005 and also created setup project of that application. now i want to install SQL Server Express edition with my application. so i have checked SQL Server Express 2005 in Setup Project Properities(Prerequisites...). now i want to change SQL Secirty Mode during setup. and i don't know how can we do this?
I have noticed in the database logs that someone is trying to log into our SQL Server express databases, is there a way of allowing only IP address on a list to access the database. We really only need the local machine and the office using SQL Express management studio to access the database.
I would appreciate any help sometimes the database runs very slow and we do not know what is causing this.
We are running server 2003 and SQL Server express.
hi i am using vc# 2005 and sql 2005 express. my problem is does exist any way to set password on sql2005 database ? (because i don't want to end users access to sql server's tables and datas and ...) how to solve my problem ? thanks
Hi,I'm building an asp.net website using web developer express and I have a SQL 2005 express install on the same machine. Using windows security, everything works fine for development.Now I need to get it working at the client site, where the web server and SQL 2005 Express are on different machines.I'd tried using windows authentication but that didn't work, probably wasn't doing it correctly. I'd like to try SQL Authentication, at least temporarily, since I can replicate that on my laptop at home easily I think.I created a new SQL login but was really baffled by the screens showing roles and schemas, etc. There's so many roles to choose from and wasn't sure if this new login needed to own any schemas. I did turn on remote connections and mixed-mode authentication, the probably now is my asp.net membership provider login page isn't authenticating correctly, maybe my permissions are wrong on the aspnet_..... tables for users, roles, profiles, etc. Any advice?thanks,Bruce
When I installed VS 2005, it installed the default version of SQL Server 2005 Express that ships with Visual Studio 2005 installer media.
How can apply SQL Server 2005 Express SP1 to update this existing instance?
Currently, if I run this query:
SELECT @@version
I get the following:
Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
After applying SP1, I should get 9.00.2047.00.
Should I just go to this link and download & install the SQL Server 2005 Express Edition SP1:
We are releasing an application built on SQL Server Express in the next few months. Our clients are mostly small companies with little technical knowledge, and they will be using our application on desktop computers where everyone likely logs in as the same user. As such, my thinking is that we setup SQL Server Express as in SQL Server Authentication mode. This way they could select an Administrator password upon first installation, and manage user names and passwords from within the application itself.
If i have been using sql server 2005 express for developing my application and i decide to upgrade to sql server 2005 express with advanced services while still working on the same application, what will happen to my application's database. Can i be able to continue with my work with out any major regrets.
2) right click a page in the vs2005 IDE and browse
3). browse a page from the IIS snap in
it doesn't work from other peoples PC on our intranet say if someone types:
http://xxx.xxx.xx.xx/mywebapp/default.aspx because I get this result:
Server Error in '/FocusII_Website' Application. --------------------------------------------------------------------------------
User does not have permission to perform this action. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: User does not have permission to perform this action.
Source Error:
Line 82: Line 83: SqlDataAdapter da = new SqlDataAdapter(sql, ConfigurationManager.ConnectionStrings["sqlExpress"].ToString()); Line 84: da.Fill(ds); Line 85: RadGrid1.DataSource = ds; Line 86: RadGrid1.DataBind();
Is there a way to implement Access-like password protection on a SQL Server Express dataset?
The database will be deployed on individual's PCs with no centralization of control. I want to restrict users from being able to see table definitions, stored procedures, etc. Access-like password protection is what I want, but I don't see any similar feature within SQL Server Express. Am I missing something?
Hi, I'm quite new to SQL Server Express and am having trouble with security. I have SQL Server Express installed on one of our servers and want to limit access to this instance of SQL Server, and basically grant access to only certain users within our organisation. However it seems that by default everyone can connect to SQL Server.
First of all I enabled local and remote connections. I did not grant anyone access permissions under Logins, and then went back to my workstation and tried to connect to the instance of SQL Server using SQL Server Management Studio which I have installed locally. I presumed and hoped that it would come up with a message saying that I don't have access permissions to connect to SQL Server, but instead it let me connect and even create a new database.
I then went back to the server and changed EACH Login to Deny under Login Properties -> Status -> Permission to connect to Database Engine. Then I returned to my client and tried to connect again and it still succeeds and allows me to create/delete tables/ databases/etc.
Can someone please explain why this is? If any more details are required to answer this question let me know.
Please how are security patches for SQL Server Express 2005 made available (e.g., as seperate distributions or bundled into other Microsoft patch distribution mechanisms)? Are there specific procedures that I need to put in place to ensure that SQL Server Express 2005 gets patched on end user machines?
I'm trying to learn some VB programming with the VB 2005 Express Absolute Beginner Series video tutorials (which I think is great) and have come across a problem that I can't solve.
When I follow the instructions in Lesson 9 (Databinding Data to User Interface Controls) my application will display the data from the database correctly and I can edit it (and as long as the debugger is running the data remains changed). However, the changes won't propagate back to the database. I don't get any error messages but after I edit the data, save (with the save button on the BindingNavigator toolbar), and end debugging the data in my database remains unchanged. When I use a MessageBox to show how many rows where edited/updated in the
I get the correct number back. I'm sure the problem is not due to coding errors since I've also tried running the accompanying Lesson 9 project file that can be downloaded from MSDN and the problem persists.
I'm using Windows XP SP2, SQL Server 2005 Express Edition and VB 2005 Express Edition. I've tried installing SQL Server 2005 Express with a number of different settings, including default settings, but it doesn't make any difference.
Would greatly appreciate any feedback on this as I'm keen to resolve this problem so I can get on with the next tutorial lesson.
HiIm trying to connect Visual Basic Express 2005 to a remote SQL Server Express 2005. I cant find how i can do that in VB.net Express.In Web developer there are no problem to connect to a remote SQL server but i cant find it in VB.net Express. The XP with the SQL server that i want to connect to is on the local network. Greatful for help!
Hi Guys, I created a Product database table using Visual Basic 2005 Express and SQL Server 2005 Express. I have just added a new column [Picture] to the database table, which of course, should store an image or picture of a product. I am writing to kindly ask you guys for help .
i) How do I include image files into this column [Picture]? ii) How do I get this image to display on Visual Basic 2005 Express form, so that when a product is selected the product image is displayed accordingly?
Hi, I want to make a component library in Visual Basic.NET and connect to a remote Sql Server. When I create a new DataSet with the wizard, I can only connect to a .mdf file, but not to a Sql Server. With Visual Web Developer I can connect to a Sql server. What is the difference between these enviroments ? How can I do the same with Visual Basic.NET ? Thanks in advance.
Hello, I'm installing MOSS 2007 as stand alone which includes SQL Server 2005 Express edition. My install is failing during the DB install. The server is Windows Server 2003, Enterprise Edition SP 2.
The error I'm receiving states "Setup has encountered an unexpected error while updating security settings on HTTP Services".
Here are snippets including the "return value 3" found in the log "SQLSetup0001_COHNTFS15_SQL.log".
Snippet 1: <Func Name='LaunchFunction'> Function=Do_sqlPerfmon2 <Func Name='GetCAContext'> <EndFunc Name='GetCAContext' Return='T' GetLastError='0'> Doing Action: Do_sqlPerfmon2 PerfTime Start: Do_sqlPerfmon2 : Thu May 01 08:36:14 2008 <Func Name='Do_sqlPerfmon2'> <EndFunc Name='Do_sqlPerfmon2' Return='0' GetLastError='2'> PerfTime Stop: Do_sqlPerfmon2 : Thu May 01 08:36:14 2008 MSI (s) (D8:EC) [08:36:14:535]: Executing op: ActionStart(Name=Do_PropSetLoginModeNT.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Setting SQL Server Authentication Mode,) <EndFunc Name='LaunchFunction' Return='0' GetLastError='0'> MSI (s) (D8:EC) [08:36:14:535]: Executing op: CustomActionSchedule(Action=Do_PropSetLoginModeNT.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_PropSetLoginModeNT,CustomActionData=010Setting SQL Server Authentication Mode50000MSSQL.1) MSI (s) (D8:40) [08:36:14:535]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI538.tmp, Entrypoint: Do_PropSetLoginModeNT <Func Name='LaunchFunction'> Function=Do_PropSetLoginModeNT <Func Name='GetCAContext'> <EndFunc Name='GetCAContext' Return='T' GetLastError='0'> Doing Action: Do_PropSetLoginModeNT PerfTime Start: Do_PropSetLoginModeNT : Thu May 01 08:36:14 2008 <Func Name='Do_PropSetLoginModeNT'> Switching server to NT integrated security <EndFunc Name='Do_PropSetLoginModeNT' Return='0' GetLastError='0'> PerfTime Stop: Do_PropSetLoginModeNT : Thu May 01 08:36:14 2008 MSI (s) (D8:EC) [08:36:14:566]: Executing op: ActionStart(Name=Do_HttpServiceSecurity.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Updating security settings on HTTP services,) <EndFunc Name='LaunchFunction' Return='0' GetLastError='0'> MSI (s) (D8:EC) [08:36:14:566]: Executing op: CustomActionSchedule(Action=Do_HttpServiceSecurity.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_HttpServiceSecurity,CustomActionData=100Updating security settings on HTTP services100000) MSI (s) (D84) [08:36:14:566]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI539.tmp, Entrypoint: Do_HttpServiceSecurity <Func Name='LaunchFunction'> Function=Do_HttpServiceSecurity <Func Name='GetCAContext'> <EndFunc Name='GetCAContext' Return='T' GetLastError='0'> Doing Action: Do_HttpServiceSecurity PerfTime Start: Do_HttpServiceSecurity : Thu May 01 08:36:14 2008 <Func Name='Do_HttpServiceSecurity'> Error updating HTTPFilter service security (5)
<EndFunc Name='Do_HttpServiceSecurity' Return='1603' GetLastError='0'> PerfTime Stop: Do_HttpServiceSecurity : Thu May 01 08:36:14 2008 Gathering darwin properties for failure handling. Error Code: 1603 MSI (s) (D8!20) [08:36:14:785]: Product: Microsoft SQL Server 2005 Express Edition -- Error 29528. The setup has encountered an unexpected error while Updating security settings on HTTP services. The error is: Fatal error during installation.
Error 29528. The setup has encountered an unexpected error while Updating security settings on HTTP services. The error is: Fatal error during installation.
<Failure Type='Fatal' Error='1603'> <EndFunc Name='LaunchFunction' Return='1603' GetLastError='0'> MSI (s) (D8:EC) [08:36:14:800]: User policy value 'DisableRollback' is 0 MSI (s) (D8:EC) [08:36:14:800]: Machine policy value 'DisableRollback' is 0 Action ended 8:36:14: InstallFinalize. Return value 3.
Snippet 2: <Func Name='LaunchFunction'> Function=Set_CommitFlag <Func Name='GetCAContext'> <EndFunc Name='GetCAContext' Return='F' GetLastError='0'> Doing Action: Set_CommitFlag PerfTime Start: Set_CommitFlag : Thu May 01 08:36:22 2008 <Func Name='Set_CommitFlag'> Set_CommitFlag called successfully.Rollbacked <EndFunc Name='Set_CommitFlag' Return='0' GetLastError='0'> PerfTime Stop: Set_CommitFlag : Thu May 01 08:36:22 2008 <EndFunc Name='LaunchFunction' Return='0' GetLastError='0'> MSI (s) (D8:EC) [08:36:22:988]: Executing op: ActionStart(Name=RollbackSupportFiles.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Removing temporary files,) MSI (s) (D8:EC) [08:36:22:988]: Executing op: CustomActionRollback(Action=RollbackSupportFiles.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1281,Source=BinaryData,Target=RollbackSupportFiles,) MSI (s) (D8:7C) [08:36:22:988]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI54B.tmp, Entrypoint: RollbackSupportFiles MSI (s) (D8:EC) [08:36:23:004]: Executing op: End(Checksum=0,ProgressTotalHDWord=0,ProgressTotalLDWord=0) MSI (s) (D8:EC) [08:36:23:004]: Error in rollback skipped. Return: 5 MSI (s) (D8:EC) [08:36:23:004]: Entering MsiProvideAssembly. AssemblyName: Microsoft.AnalysisServices.AdomdClient,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.2047.0", AppContext: , InstallMode: -4 MSI (s) (D8:EC) [08:36:23:004]: Pathbuf: 0, pcchPathBuf: 0 MSI (s) (D8:EC) [08:36:23:019]: MsiProvideAssembly is returning: 1607 MSI (s) (D8:EC) [08:36:23:019]: Entering MsiProvideAssembly. AssemblyName: Microsoft.SqlServer.Instapi,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.1399.0", AppContext: , InstallMode: -4 MSI (s) (D8:EC) [08:36:23:019]: Pathbuf: 0, pcchPathBuf: 0 MSI (s) (D8:EC) [08:36:23:019]: MsiProvideAssembly is returning: 1607 MSI (s) (D8:EC) [08:36:23:019]: Entering MsiProvideAssembly. AssemblyName: Microsoft.SqlServer.SqlTDiagM,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.1399.0", AppContext: , InstallMode: -4 MSI (s) (D8:EC) [08:36:23:019]: Pathbuf: 0, pcchPathBuf: 0 MSI (s) (D8:EC) [08:36:23:035]: MsiProvideAssembly is returning: 1607 MSI (s) (D8:EC) [08:36:23:035]: Entering MsiProvideAssembly. AssemblyName: MSClusterLib,Version="1.0.0.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="1.0.0.0", AppContext: , InstallMode: -4 MSI (s) (D8:EC) [08:36:23:035]: Pathbuf: 0, pcchPathBuf: 0 MSI (s) (D8:EC) [08:36:23:050]: MsiProvideAssembly is returning: 1607 MSI (s) (D8:EC) [08:36:23:050]: Entering MsiProvideAssembly. AssemblyName: Microsoft.SqlServer.MgdSqlDumper,Version="9.0.242.0",Culture="neutral",processorArchitecture="x86",PublicKeyToken="89845dcd8080cc91",FileVersion="2005.90.1399.0", AppContext: , InstallMode: -4 MSI (s) (D8:EC) [08:36:23:050]: Pathbuf: 0, pcchPathBuf: 0 MSI (s) (D8:EC) [08:36:23:050]: MsiProvideAssembly is returning: 1607 MSI (s) (D8:EC) [08:36:23:050]: Entering MsiProvideAssembly. AssemblyName: Microsoft.SqlServer.Rmo,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.2047.0", AppContext: , InstallMode: -4 MSI (s) (D8:EC) [08:36:23:050]: Pathbuf: 0, pcchPathBuf: 0 MSI (s) (D8:EC) [08:36:23:066]: MsiProvideAssembly is returning: 1607 MSI (s) (D8:EC) [08:36:23:066]: Entering MsiProvideAssembly. AssemblyName: Microsoft.AnalysisServices.DeploymentEngine,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.1399.0", AppContext: , InstallMode: -4 MSI (s) (D8:EC) [08:36:23:066]: Pathbuf: 0, pcchPathBuf: 0 MSI (s) (D8:EC) [08:36:23:082]: MsiProvideAssembly is returning: 1607 MSI (s) (D8:EC) [08:36:23:082]: Entering MsiProvideAssembly. AssemblyName: Microsoft.AnalysisServices,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.2047.0", AppContext: , InstallMode: -4 MSI (s) (D8:EC) [08:36:23:082]: Pathbuf: 0, pcchPathBuf: 0 MSI (s) (D8:EC) [08:36:23:082]: MsiProvideAssembly is returning: 1607 MSI (s) (D8:EC) [08:36:23:082]: Entering MsiProvideAssembly. AssemblyName: Microsoft.DataWarehouse.Interfaces,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.2047.0", AppContext: , InstallMode: -4 MSI (s) (D8:EC) [08:36:23:082]: Pathbuf: 0, pcchPathBuf: 0 MSI (s) (D8:EC) [08:36:23:097]: MsiProvideAssembly is returning: 1607 MSI (s) (D8:EC) [08:36:23:097]: Entering MsiProvideAssembly. AssemblyName: Microsoft.SqlServer.RegSvrEnum,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.2047.0", AppContext: , InstallMode: -4 MSI (s) (D8:EC) [08:36:23:097]: Pathbuf: 0, pcchPathBuf: 0 MSI (s) (D8:EC) [08:36:23:113]: MsiProvideAssembly is returning: 1607 MSI (s) (D8:EC) [08:36:23:113]: Entering MsiProvideAssembly. AssemblyName: Microsoft.SqlServer.BatchParser,Version="9.0.242.0",Culture="neutral",processorArchitecture="x86",PublicKeyToken="89845dcd8080cc91",FileVersion="2005.90.2047.0", AppContext: , InstallMode: -4 MSI (s) (D8:EC) [08:36:23:113]: Pathbuf: 0, pcchPathBuf: 0 MSI (s) (D8:EC) [08:36:23:113]: MsiProvideAssembly is returning: 1607 MSI (s) (D8:EC) [08:36:23:113]: Entering MsiProvideAssembly. AssemblyName: Microsoft.SqlServer.ServiceBrokerEnum,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.2047.0", AppContext: , InstallMode: -4 MSI (s) (D8:EC) [08:36:23:113]: Pathbuf: 0, pcchPathBuf: 0 MSI (s) (D8:EC) [08:36:23:129]: MsiProvideAssembly is returning: 1607 MSI (s) (D8:EC) [08:36:23:129]: Entering MsiProvideAssembly. AssemblyName: Microsoft.SqlServer.WmiEnum,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.2047.0", AppContext: , InstallMode: -4 MSI (s) (D8:EC) [08:36:23:129]: Pathbuf: 0, pcchPathBuf: 0 MSI (s) (D8:EC) [08:36:23:144]: MsiProvideAssembly is returning: 1607 MSI (s) (D8:EC) [08:36:23:144]: Entering MsiProvideAssembly. AssemblyName: Microsoft.SqlServer.ConnectionInfo,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.1399.0", AppContext: , InstallMode: -4 MSI (s) (D8:EC) [08:36:23:144]: Pathbuf: 0, pcchPathBuf: 0 MSI (s) (D8:EC) [08:36:23:160]: MsiProvideAssembly is returning: 1607 MSI (s) (D8:EC) [08:36:23:160]: Entering MsiProvideAssembly. AssemblyName: Microsoft.SqlServer.SqlEnum,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.2047.0", AppContext: , InstallMode: -4 MSI (s) (D8:EC) [08:36:23:160]: Pathbuf: 0, pcchPathBuf: 0 MSI (s) (D8:EC) [08:36:23:207]: MsiProvideAssembly is returning: 1607 MSI (s) (D8:EC) [08:36:23:207]: Entering MsiProvideAssembly. AssemblyName: Microsoft.SqlServer.SmoEnum,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.2047.0", AppContext: , InstallMode: -4 MSI (s) (D8:EC) [08:36:23:207]: Pathbuf: 0, pcchPathBuf: 0 MSI (s) (D8:EC) [08:36:23:207]: MsiProvideAssembly is returning: 1607 MSI (s) (D8:EC) [08:36:23:207]: Entering MsiProvideAssembly. AssemblyName: Microsoft.SqlServer.SString,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.1399.0", AppContext: , InstallMode: -4 MSI (s) (D8:EC) [08:36:23:207]: Pathbuf: 0, pcchPathBuf: 0 MSI (s) (D8:EC) [08:36:23:222]: MsiProvideAssembly is returning: 1607 MSI (s) (D8:EC) [08:36:23:222]: Entering MsiProvideAssembly. AssemblyName: Microsoft.SqlServer.Smo,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.2047.0", AppContext: , InstallMode: -4 MSI (s) (D8:EC) [08:36:23:222]: Pathbuf: 0, pcchPathBuf: 0 MSI (s) (D8:EC) [08:36:23:238]: MsiProvideAssembly is returning: 1607 MSI (s) (D8:EC) [08:36:23:238]: No System Restore sequence number for this installation. MSI (s) (D8:EC) [08:36:23:238]: Unlocking Server MSI (s) (D8:EC) [08:36:23:238]: PROPERTY CHANGE: Deleting UpdateStarted property. Its current value is '1'. Action ended 8:36:23: INSTALL. Return value 3.
last few lines of log: Property(S): RSVirtualDirectoryManager = Reports$OFFICESERVERS Property(S): SOURCEDIR = d:a1847ef4f3beaf9c2353Setup Property(S): SourcedirProduct = {2AFFFDD7-ED85-4A90-8C52-5DA9EBDC9B8F} Property(S): InstallNgenTicks = 110000 Property(S): SQLBROWSERACCOUNT = NT AUTHORITYNETWORK SERVICE Property(S): SQLBROWSERSCMACCOUNT = NT AUTHORITYNetworkService Property(S): SQLSCMACCOUNT = NT AUTHORITYNetworkService Property(S): DebugClsid.CC1A8C58_27D1_4D38_BF1B_C0A5CBB90616 = {B266876E-56D9-493C-9322-0C01155F1C52} Property(S): ProductToBeRegistered = 1 MSI (s) (D8:EC) [08:36:23:441]: Note: 1: 1708 MSI (s) (D8:EC) [08:36:23:441]: Product: Microsoft SQL Server 2005 Express Edition -- Installation failed.
MSI (s) (D8:EC) [08:36:23:457]: Cleaning up uninstalled install packages, if any exist MSI (s) (D8:EC) [08:36:23:457]: MainEngineThread is returning 1603 MSI (s) (D84) [08:36:23:566]: Destroying RemoteAPI object. MSI (s) (D8:E0) [08:36:23:566]: Custom Action Manager thread ending. === Logging stopped: 5/1/2008 8:36:23 === MSI (c) (104) [08:36:23:597]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1 MSI (c) (104) [08:36:23:597]: MainEngineThread is returning 1603 === Verbose logging stopped: 5/1/2008 8:36:23 ===
I'm suspecting it's a permission error, but I can't verify this. Any thoughts? Thanks in advance.
Q1: Does Sql Server 2005 Express support Web/Internet to other SQL Server 2005 Express Clients or does it have to Synch across the internet to a fully installed setup SQL Server 2005 with IIS?
Q2: Does SQL Server 2005 Express support Direct Replication between other SQL Server 2005 Express clients?
I have a question regarding the security of SQL Server 2005 Express Edition. What securities options that SQL server 2005 EE provide for its users?
I know that after I deploy my website to a hosting company or a web server, my database file will be on the net. That means everybody can type in the file name and download my database file then open it. Just like that. For example, my database filename is EXAMPLE.MDF. then, someone just goto my website, say http://www.cool.com/app_data/example.mdf, and download the database.
To prevent that to happen, what the securities options that available to me beside putting password on my database file?
Thanks for taking time to answer my question. Any help will be appreciated. Have a good day!
HI, I am just starting out with SQL Server 2005 and really getting in a muddle with al the security stuff. It seems i have LOGINS, DATABASE USERS, Server Roles, Database Roles, SCHEMAS and somehow they all tie in together. I am using Microsoft Press "SQL Server 2005 Implementation and maintenance" but it really isn't doing a good job of explaining it to me. Can anyone point me to a reference that clearly explains all this stuff?
I have been building a database in SQL Server Express for some months now using the Windows level authentication login that has given me full access to everything in the database.
The time has now come where I need to create user accounts and grant permissions to specific stored procedures and I'm having trouble doing this.
Can anyone give me a brief rundown of the required T-SQL commands I need to set up a user account that can do nothing but run stored procs (not the system procs which apparently are being discontinued: http://msdn2.microsoft.com/en-us/library/ms182795.aspx).
So far I have:-
CREATE LOGIN db_test_user WITH PASSWORD = 'eXaMpL3Pwd USE db_new CREATE USER db_test_user
The above code executes successfully but when I try and connect (using Management Studio) I get error message 'The user is not associated with a trusted SQL Server connection (error 18452)' which means little to me.
I also tried creating a 'WITHOUT LOGIN' user for the database but could not figure out how to give it a password.
I don't know (/understand) roles/schemas and don't know if I really need them as I only need user access to specific stored procs. I don't ever want them to see the tables for example so they only need the most restricted access.
I cannot block user access to tables. I have restriced accounts at theserver, database, group, schema, and table lavel and can still opentables right up.In other words, I have absolutely no security. Any ideas?
Does anybody have a link to either of these two documents. My company is getting ready to go through an audit and we need some firepower and to know what is expected. Any help with obtaining microsoft SQL Server 2005 best practices documents is appreciated.
Couple of questions for the SQL Server Guru's out there.
SQLServer 2005 Web Hosting Provider
Ok I am developing a Web application in ASP.NET with AJAX, etc. etc. It will be some time before it is ready to roll out. As a mockup I created the same application in Microsoft Access and Visual Basic (VS 2008), which I can link the tables to the hosting provider on the internet. Works very well and speed is very acceptable. The want to start utilizing it with the mockup distributed app that I created.
My question is, is how secure is the data that is moving from the local application to SQLServer 2005 with the web hosting provider ? Is there anything that I can do to increase security ?
Dear mems, I have a problem, and i don't khow how to resolve, pls help me:
My server is Windows XP (not domain), I work with SQL Server 2005, installed on my server, I configurate my SQL SERVER connection is "Windows Authentication mode", I add user "MyComputerguest" to MyServerSecutityLogins to accept connections from local network I have many databases: Db1, Db2, Db3...
But, I don't know to configurate my SQL Server to achive these: 1) My clients using "SQL Server Managment Studio" connect to Databases Db2, Db3... on my Server, they can expand, modify, add new all Tables, Sp, functions of Db2, Db3. 2) My clients are not allow to access Db1. 2) My clients can add new Databases Db4, Db5, Db6... in the future and they have full permission on every Database which they create without my interfere.
if you run the following script it takes access from the windows admin from getting into sql server through windows auth. The issue is that the files that are attached logging as SA after that are read only. Is there any solution? When you try and switch the file to read write sql server gives an error saying that it cant read the mdf and ldf--gives a windows access error....
USE [master] GO
IF EXISTS (SELECT * FROM sys.server_principals WHERE name = N'BUILTINUsers') EXEC sp_dropsrvrolemember [BUILTINUsers], sysadmin DENY CONNECT SQL TO [BUILTINUsers] CASCADE GO
IF EXISTS (SELECT * FROM sys.server_principals WHERE name = N'BUILTINAdministrators') EXEC sp_dropsrvrolemember [BUILTINAdministrators], sysadmin DENY CONNECT SQL TO [BUILTINAdministrators] CASCADE GO
IF EXISTS (SELECT * FROM sys.server_principals WHERE name = N'NT AUTHORITYSYSTEM') EXEC sp_dropsrvrolemember [NT AUTHORITYSYSTEM], sysadmin DENY CONNECT SQL TO [NT AUTHORITYSYSTEM] CASCADE GO
I am not sure if this is the right place to post this but I need some help. We have an email server, with windows 2003 server, set up with SQL server 2005 and sql server management studio express which uses windows authentication. I noticed in the event viewer we keep getting an error under the application, "failure audit". about 25 a minute. The error says "login failed for user admin The user is not associated with a trusted mysql server connection." followed by an ip address (this username changes on a daily bases which makes me wonder if it is an attempted hack) I have little knowledge of sql. How can I get this to stop happening. Event Viewer returns no results to help me fix this and I am having no luck researching it on my own. If there is any more info I need to provide, let me know. HELP!
