is there) and accessing it's "properties" enable it in the "Status" tab (again, it's no longer a tab :D) in the "Security" node, "logins", you can see all the registered logins, both Windows accounts/groups, and SQL Server standard logins I do only have BUILTIN\Administrators, "sa", NT AUTHORITY\System if you have further, like BUILTIN\Users, this imply all your local users will be able to connect to your instance.. they have then to be granted access to each database via a database user (and I think I already pointed out that story).. but are you perhaps using "User Instances"? if this is the case, then everyone who executes your application will be able
I've confirmed that MS Access will create an ADP project in MSDE only if the server is set to Mixed (SQL Server and Windows) authentication mode. Trials in Windows Authentication mode failed. This is still hard to believe, I know, but its a reality.Lou, Did you have to create users in the SQL database itself so that Domain Users could access the MSDE, and if so, with what tool did you use?
where and order by clauses) and paste it into the query section of the SQL Server Import and Export Wizard, the export processes in under 20 seconds!! Finally, if you copy the database to another SQL Server 2008 SP1 server and run the same combination of tests, the results are the same. All of this suggests to me that the problem lies with SQL Server Import and Export Wizard (in SQL Server 2008) - in the way that it is parsing this particular view when left to it's own devices. Microsoft, can you please explain why the SQL Server Import and Export Wizard in SQL Server 2008 is behaving this way?? Do you have any suggestions as to how I can overcome this problem?I have been looking for an answer to this same question in various forums with no luck. I have encountered the
Hi I wonder how the 4 GB limit is found. Is it the size of the datafile only, or does the size also inlcude the transaction log? Kjell Arne Johansen Kongsberg Maritime asHello, The 4 GB database size limit applies only to data files and not to log (LDF) files. However, there are no limits to the number of databases that can be loaded/created to the SQL server instance. HariThank you for your answer.
when using an asp page with DSN connection. I installed .NET and created an ASP.NET page and can no longer connect with the following error: [DBNETLIB][Connection Open] SQL server does not exist or access denied. The connection string is: value="Persist Security Info=False;Data Source=[BILLCPU];Initial Catalog=[MASTER_DB];User ID=;Password=;" There are quite a few posts about this but none have seemed to solve the problem. The database is running fine, I have access rights to the database, The SQL client network utility uses TCP/IP and Named Pipes in that order, I have deleted the alias names in the client utility, I tried replacing the server name in Data source with an IP Number but still haven't installed it. Any advice is greatly appreciated hi
come with visual management tool (Enterprise Manager) and a few limitations on its functionalities. So, to you question: 1. No, MSDE does not get installed when you install full SQL Server. If the SQL Server on your computer is for development, there is not need to put MSDE, unless you want to learn how to integrate your app with MSDE (for example, learn how to use command line to manage SQL Server/MSDE, as oppose to Enterprise Manager). 2. MSDE allows up to 8 concurrent access (3 used by itself?), meaning there is no difference from full SQL Server when less then 8 concurrent access. When more accesses reach the MSDE, it will slow down the process greatly (to encourage you switch to full SQL Server!). Note, it is concurrent access count, not number of users who use the MSDE database
I have selected a wrong group, but it is a question which appears often on Google Groups, because I have been looking there, but rarely gets an answer. These two queries, run fine against an MDB file, but neither of them work against SQL server, from VB at least.. I have been unable to find a definitive answer, particularly to the second output to text type query. I have seen complex XML transformations, and some elaborate workarounds to get the result, but no SQL methods. How do I implement the functionality into SQL server that these two queries represent? I can not believe that MS just dropped such convenient syntax. So it must be my lack of knowledge. SELECT [Poultry types].* INTO New_Table IN 'C:\NewDatabase.MDB FROM [Poultry types]; SELECT [Poultry types].ID, [Poultry
Express 2005 on it. I copied the .MDF files from the MSDE unit and attached them to SQLExpress. Now, when I try to connect to the databases, I get the "SQL Server does not exist or access is denied" error. I have, of course, modified the connection string such that the Data Source property is using the correct computer name. I've looked at everything I can think of but obviously I'm missing something fundamental here. Any suggestions as to what I might be doing wrong?hi Martin, please verify the instance name is correct (in the form ComputerName\InstanceName), the remote computer can access the lan and the remote SQLExpress installed computer, firewall (both) have been set with the appropriate exception(s) allowing connectivity and trafic (both the DBEngine used
Express Manager in which it is stated that it will allow easy database management and query analysis capabilities, will have a small download size, and will be freely redistributable. And further, that it will support connections to SQL Server Express and other SQL Server 2005 editions, SQL Server 2000, and MSDE 2000. Now I am starting to get interested in this GUI, but for the life of me I am unable to find an actual download for it. Could someone please point me to where I can actually download XM MattIt's not out yet. Apparently there's not an expected date, either. Soon, soon .. kipWell that is a shame, it sounds like a great product, with a very appealing price. Mattappealing The "product" is not a product yet, it's still in beta
authentication area in the Security is disabled for that instance. But for an Express instance, the Server authentication area is enabled. Is this difference caused by some settings? Peterhi Peter, you are lucky.. from my local SSMS (the big brother of SSMSE) I can connect to remote SQL Server/MSDE instances, I can manage tables, views, stored procedures and the like, but often SSMS freezes (and SSMSE) as well as soon as I right click on the server node but if it not freezes, then I can manage security (both with SSMS and SSMSE) as desired/required.. my SSMSE is not the CTP build but the RTM, released with SQL Server 2005 sp1, as per http://www.microsoft.com/downloads/details.aspx?familyid=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=enHi Andrea, I'm using
Hello, We have a VB 6 program using MS Access that is distributed to many remote locations. We would like to convert the application to use SQL Server Express. We would like the Exress database to have a number of it's columns encrypted using the new encryption capability in SQL Server 2005. Will the Express version allow you to distribute the database with columns encrypted? Thanks!hi, AFAIK, SQLExpress will support encryption
of the soundtrack from Purple Rain? Some people like that music, but not everybody does. And not everybody owns a CD player, either.before If your XML data is non-relational and you are not using it for relational purposes, then what are you gaining by spending money on a SQL Server license, versus storing the XML files on disk?The main things you are going to gain concern performance. Try to put many many files (more than 10.000 XML files) into a folder and access it (even in NTFS). You can put in a database indexes that allow you to access directly to the information you need. In SQL Server 2005, you will also can add columns based on XML you store in the database and also add index on these columns. Phil. stillThis is a windows explorer problem specifically, and has nothing
How to make SQL Server Management Studio Express (SSMSE) CTP to start when SQL Server Books Online is also installed? SQL Server Management Studio Express CTP is starting at once when SQL Server Books Online is removed from Control Panel/Add or Remove Programs! :( I'm using the latest, today downloaded, versions of these both.Mika, Thanks for your post. I was seeing the same thing and didn't know why my SSMSE wasn't launching. I've installed and un-installed. I didn't connect the issue with BooksOnLine. I have since removed BOL and my SSMSE is now launching. Anyone aware of a fix or KB article. Fritz
I 'm trying to install Sql Server 2005 Express Edition using c# . I also want to informed about installation progress. For instance i want to inform end user if any installation error return. I think i need a callback I have no problem about silent install but how can i informed about installation progress ? Any suggestion ?Try this:- http://msdn2.microsoft.com/en-us/library/ms144259.aspx about halfway through you will see a list of params that are supported at install inc. ErrorReporting. Good luck. Phil
Personnal Edition 2000 is installed. I've installed MSDE 2000 on another Win2K PC. Both have the same database locally attached (the whole application required distinct SQL Server from 2 geographical locations. Both server will gather data from their respective site and must be synchronized automatically so that both database have the same informations all the time). On the MSDE PC, I can see the remote SQL Server and I can connect into it (with a third-party software, MSDE Manager). In the SQL Server Service Manager, I effectivly see both servers. But in the first PC, where the SQL Server 2000 is installed, I can't connect to the MSDE. I don't see it in the Service Manager neither. Both PCs are logged with the same user/password with administrative privileges. I use
a given PC. We are using a text that supplies .mdf files as part of the support materials for the book. We are able to copy the .mdf files to the appropriate directory (..\Microsoft SQL Server\MSSQL$InstanceName\Data), then use Server Explorer in VS .NET to create a database link to the file (Connect To Database button on the Server Explorer toolbar). Once VS .NET is restarted, the database appears in the list of databases under the SQL Server instance and is fully accessible. I now want to create additional SQL Server databases for students to use with development projects, etc. I have access to the SQL Server GUI management tools (from our MSDNAA subscription) and they are installed and working with the MSDE instance on my office PC. When I create a database/tables/etc. on my
Is there an Import/Export wizard like SQL Server 2000? I am thinking of developing databases in SQL Server 2005 Express. When done I will need to transfer the tables/data to a SQL Server 2000 database. I normally use the "Import and Export Data" tool to transfer items. Is there a matching tool in SQL Server 2005 Express? Would this tool handle going from SQL Server 2005 to SQL Server 2000? Thanks in advance, Randyhi Randy, SQLExpress does not provide BI tools (DTS Wizard in SQL Server 2000) to perform this kind of oerations you have to manually perform data-pumping the way you like.. BCP, BULK INSERT, INSERT INTO, ADO.Net/ADO or the like..
I have done all my develpment work with the Developer edition of SQL. The hosting service I am using has MSDE 2000 installed on my Windows 2000 Server. I have installed the application DBAMGR to provide a tool for working with the database. Using DBAMGR, I was able to connect to the SQL server and create a new database (Database1) and table (Table2). My problem occurs when I try to access the database from my WebService connection code. I get SQL database does not exist or access is denied. Now, my new database and table appear to be controlled by dbo in sql. Any suggestions? Private con As New SqlConnection("Data Source=localhost;trusted_connection=true;Initial Catalog=Database1") Dim stringSQL As String = "Select SectionID,ID,ParentID,ChildIndexList
hi Gerald, it seems you do not have firewall troubles, but standard security problems, as OFFICEPC\.. users are not granted login to MSDE instance please verify your Logins can you telnet on port 1433 the MSDE instance?Hi Andrea - thanks for answering I think you are right about it being a standard security problem. How do I telnet on port 1433, and How do I grant login to my MSDE instance?hi Gerald in order to grant your 'OFFICEPC\xxxx' users, you have to add them to the SQL Server Windows logins please have a look at http://support.microsoft.com/default.aspx?scid=kb;EN-US;q325003#8 for further info about granting login to Windows logins/groups
'SQLOLEDB' I have checked the MDAC_TYP using the MDAC_TYP Checker, and both the SQL Server and MSDE Machines have the same version running. I have pinged the SQL Server from the MSDE Server and they can both see each other. Any suggestions you might have would be greatly appreciated!! Thanking you in advance, m00nm0nkey!!Pinging the servers does not prove anything other than each PC is on the network. Can you connect to the MSDE Server through Enterprise Manager (adding it to the default Server Group) on the SQL Server machine. If yes, it is most likely something wrong in how you have defined the link or referencing the SQL Server in your queries. If no, then it would suggest the MSDE Server does not have the Network Protocols enabled (turned off by default in a normal
I am running SQL Express 2005 and I need to install the SQL Server Agent so I can use it to do backups. How do I do that?hi, SQL Server Agent is not available in the SQLExpress (both editions) SKU.. for scheduled tasks you have to rely on alternate solutions, usually using the OS native scheduler, similar to http://www.sqldbatips.com/showarticle.asp?ID=27 and http://www.sqldbatips.com/showarticle.asp?ID=29 .. third party solutions provides an alternate scheduler like http://www.valesoftware.com/products-express-agent.php (commercial) or http://www.codeproject.com/KB/database/SQLAgent.aspx (free)..
Someone posted a similar question about a year ago with no real solution given. The problem: My computer will not automatically connect to my local SQL Server upon boot up unless I am a user with administrative rights. In fact, my own computer name doesn't exist in the SQL Service Manager at all. If I type it in, my application can access my local SQL server, BUT it won't connect to our actual SQL Server box. When I log in as Administrator, the SQL Server Manager automatically connects to the local SQL Server, and my computer name is in the list of the Service Manager. If I run our application, it will connect to our SQL Server box without a problem. What I have done: - I have installed Windows 2000 Professional from fresh. - I create a new Windows user account called '
2005 Express Edition x86 returned an unexpected value. ***EndOfSession*** Not quite sure what to do at this point. Any help would be appreciated.Look in the C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files directory for the SQL Server setup log files. There should be more information there about what happened.I finally got Sql Server to install. I actually had to remove the existing Sql Server installation, which basically had the client tools installed since it errored out the first time trying to install Express, and then I had to remove all the keys in the registry under HKLM\Software\Microsoft\Microsoft Sql Server\90. After I did that, I ran the Sql Server Setup again from the Visual Studio DVD. (DVD Drive\vs\wcu\SSE\sqlexpr32.exe) and it installed just
I'm unable to install SQL SERVER 2005 develop ed. and VISUAL STUDIO 2005 in the same computer. I have tried to install several times from different ways and all was with error. I understand that I have to uninstall all previous versions os SQL and VS. I done it. I understand that first I have to install is SQL Server and after VS selecting "custom" installation choice and deselecting the last entry in the list: "Express Edition of SQL Server" Doing so, I have installed SQL SERVER sucessfully. But, when tried to install VS the Window's installation disappear without tellling nothing. No error, no message. Don't arrive to the installation options ! Please, someone could give some help ? Thanks!Hello again, finally I have solve that problem reinstalling
Desktop SP3 which installed MDAC 2.7 on its own. This had the effect of hosing my machine by replacing version 8 dll's with earlier versions. After a few hours I resorted to recovering using system restore on windows xp pro. Has anyone else attempted to install SQL Server 2000 SP3 after installing MDAC 2.8. What is the workaround for this problem?Use SP3a? Install the latest MDAC *after* installing SP3a?I did use SP3a! Installing MDAC *after* installing SP3a is very obvious and not the type of response i was hoping for Please Let me clarify: How can you install SQL Server 2000 Desktop SP3a on a computer that *already* has MDAC 2.8 installed without hosing MDAC on that machine?of response i was hoping for Well, sorry I don't meet your stringent requirement
I am puzzled. As I mentioned, with SQL 2000 I used SQL Enterprise manager and have the login working. I have tried to map the steps I took in SQL2000's SQL EM to those in the new SQL Server Mgt. Studio Express. 1) I created a login under the server->security folder. I did not give this Login any Roles. It is just a plain ol' user (public). 2) I went to the server instance name at the top and GRANTed "Connect SQL" permission to the new Login just created; 3) I went to the database and granted "Connect" permission to the Login. After these steps I get the error reported in my earlier post. I should add that I am not an SQL Server expert and first looked at the SQL Server Mgt. Studio Express BOL.They are absolutely useless
to \Program Files\Microsoft SQL Server\ as, again, these are shared components among all instances Hi Thanks for your response below. I've mananged to install SQL server on another drive. I'm now trying to get a front end tool to install. I'm trying to install - SQL Server Management Studio Express - however I am finding the same problem. It wants to install on the C drive but I don't have enough space. This time, there is no advanced options enabling me to select a different drive. Is there anyway to that desperate for space! Down to the last 400Mb. Is it possible to use SSMSE remotely, because that would be ideal? Danhi, ROTFL yes you can install it on a separate remote machine you are required to install all related dependencies, which
to connect to Microsoft SQL Server 7.0, 2000 or 2005. SQL Native Client should be used to create new applications or enhance existing applications that need to take advantage of new SQL Server 2005 features. This redistributable installer for SQL Native Client installs the client components needed during run time to take advantage of new SQL Server 2005 features, and optionally installs the header files needed to develop an application that uses the SQL Native Client API. .." http://www.microsoft.com/downloads/details.aspx?FamilyID=df0ba5aa-b4bd-4705-aa0a-b477ba72a9cb&DisplayLang=en the SQL Server 7.0 and 2000 Client Network Utility is just a "client" tool to manage what kind of network protocol(s) should be used to connect to remote SQL Server
2003 on a new machine running as a storage machine on a peer to peer XP Professional network. I followed all the instructioons and allowed only the login password to be changed. I am now hoping to connect to the SQL Server instance from a desktop PC (i.e. remotely). I have installed SQL Server2000 developer edition on my local machine and have tried to conncet through the login presented as part of the query analyser. I can see the remote SQL Server instance in the drop down box and am entering my loginID and password. I am assuming that my login ID should be "sa" (default) and my password should match that which I set when I installed the MSDE SQL Server on the remote machine. When I go to connect a dialogue box pops up for about 30 secs informing that the computer
allow access. This is confirmed by being able to use the MSSQL v7 tools to connect to both the MSDE and the v7 servers. The error I receive when connecting to the MSDE machine is: (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1) The error I use when connecting to the v7 machine is: (provider: TCP Provider, error: 0 - A socket operation encountered a dead network.) (Microsoft SQL Server, Error: 10050) Any thoughts or ideas?hi, as long as you did not install a named instance, you only have to provide the MachineName.. obviously the relative network protocol has been enabled on the remote server.. TCP/IP 1433 is the IANA assigned port to Microsoft SQL Server, and is the default port for default instances of
I have a large, old database sitting on a server running SQL 7 and would like to move it in its entirety to a machine running MSDE so I can develop on that local machine and eventually upload the entire db to a SQL server on the net. Is this possible without too much trouble or should I go about it a different way i.e. should I create identical tables/fields in MSDE firstSimply backup and restore to your MSDE server instance. The restore process will migrate the database for you. Jim
We tried to uninstall thr SQL server but got an error that the following file was missing: Uninst.isu We tried to re-install sql server to get the file installed but no luck. We also tried to manually create the file but still it gives us the same error. Uninst.isu is missing uninstall will not continue. Any Ideas, ITS Supporthi, unfortunately, you have to manually remove the MSDE instance as you will not be able to recreate that uninstall file in order to remove an MSDE isntance, please have a look at http://support.microsoft.com/default.aspx?scid=kb;EN-US;290991
Hello all I write a program that use sqlclient to connect to SQL Server 2005 Database so how can i run this program on a computer that SQL Server 2005 is not installed on it cause it's too much for the customers to install SQL Server 2005 express edition it takes too much time and space i think if i can take the library files and make a virtual registery on the client PC it must works but i don't know how to make it please help me as soon as possibleUse the native client redistributable and redistribute it with your software. Download it here: http://www.microsoft.com/downloads/details.aspx?familyid=D09C1D60-A13C-4479-9B91-9E8B9D835CDC&displaylang=en
Connectivity;Address=ServersIP,1433;','SELECT rcIDref,rEtat from Recettes Where rSource Like 1448756'); And this is the syntax that I tried for the stored procedure: EXECUTE sp_addlinkedserver 'PROVIDERDB','SQL Server','SQLOLEDB','IPoftheProviderHost';hi, as you prepared a linked server, you are not required to use OPENROWSET as the remote server is already locally registered.. as example, on my machine I do have a default DEV edition instance and a MSDE named instance connected with the MSDE instance that will act a remote registered server, I do execute --<----------------------- SET NOCOUNT ON; USE master; CREATE DATABASE remoteDB; GO USE remoteDB; CREATE TABLE dbo.RemoteTb ( ID int NOT NULL PRIMARY KEY , IdRef int NOT NULL
know specifically if a vs.net 2005 smart device application can issue an RDA pull method (like i was able to do with vs.net 2003) to a sql server express 2005 database residing on a remote server computer. i'm actually hoping that someone can answer the question or point me to an article so that i don't have to go through extensive r&d to determine if it can be done. normally i would be more than happy to do this r&d, however, to answer this seemingly simple question would require that i purchase and install vs.net 2005, install sql server express 2005, learn how to use them, write test applications, install the test applications to devices, etc. before i go down this expensive and arduous road, i figured maybe someone might know the answer off
the DocumentItems.CustomerNumber01 field. The field names in the two different tables are the same. The issue that I have is that in the query results that SQL Server returns, it returns two columns with the same name "CustomerNumber01" and "CustomerNumber01". SQL Server is not prefixing the field names with the table names like I did when submitting the query. This makes it impossible for me the retrieve the separate field values. Is there a way to get SQL Server to return the table qualified names of these same named fields? I am using ADO with Visual Basic 6 to do the query, but I would think in theory the query should be able to be run in MS Query Analyzer or VB.hi Evan, I do not know if I correctly understood your problem, but you can "alias&