SQL Express Edition With Windows Vista
Oct 6, 2007
i've a new laptop with windows vista and i've installed vwd express edition, framwork, asp.net and sql expresse edition, but once i try to use the sql connection from the vwd, i receive an error msg "Échec de la création d'une instance d'utilisateur SQL Server en raison d'une défaillance du démarrage de processus pour l'instance d'utilisateur. Fermeture de la connexion." it's in french sorry
sql can't creat a user instance because of a process startup....
is that any update i have to download for windows vista?
thanks
mehdi
View 3 Replies
ADVERTISEMENT
Feb 11, 2008
I watched and followed the Intro to VB 2008 Express, but in the final part of the video, when you add a database, i did everything as the video says, still i get:
An error occurred creating the form. See Exception.InnerException for details. The error is: Unable to load DLL 'sqlceme35.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)
Ive tried the fix stated in another forum, the one about changing the "Target CPU" but the option doesn appear, what does appear its the "Platfrom" dropdown list, but its fixed to "Any CPU" and dont have any more options.
Ive also downloaded Microsoft SQL Server Compact 3.5 ENU and "re-installed" and selected repair, followed the steps, rebooted and still nothing.
The problem persists, any ideas, please?
View 6 Replies
View Related
Dec 26, 2007
hi,
Can we install SQL Server 2005 on MS Windows Vista Home Edition???
Please guide..
Thanks
View 4 Replies
View Related
Dec 4, 2007
I wanted to install SQL Server 2005 Express Edition, instead of installing .Net Framework 2.0, I installed .Net Framework 3.5. When I tried to install SQL Server 2005 Express Edition I received the following error:
SQL_ERROR (-1) in OdbcStatement::execute_batch
sqlstate=42000, level=16, state=2, native_error=7404, msg=[Microsoft][SQL Native Client][SQL Server]The server could not load DCOM.
Error Code: 0x80071cec (7404)
Windows Error Text: Source File Name: libodbc_statement.h
Compiler Timestamp: Wed Jun 14 16:28:15 2006
Function Name: OdbcStatement::execute_batch@sysdbupg.sql@56
Source Line Number: 91
I then decided maybe I do need .net framework 2.0, but when I try to install it it says it's already included with the OS.
But the "Programs and Featuers" only list .Net Framework 1.1 and .Net Framework 1,1 Hotfix (KB92979).
I uninstalled .Net Framework 3.5 and tried to install .Net Framework 2.0 again, but it still says it's included in the OS.
After uninstalling .Net Framework 3.5, I tried to install SQL Server 2005 Express Edition, but still received the above error message.
Is .Net Framework 2.0 included with Windows Vista Home Edition?
If it is, any ideas in solving the Server 2005 Express Edition installation error?
Thanks in advance for your help!
View 2 Replies
View Related
Oct 27, 2007
Dear friends...
I am having this problem since I installed the new windows Vista.
I am trying to install the SQL Server 2005 developer edition on Windows Vista, but After installation finish successfuly I open the start menu to surprise that I could not find the Shortcuts to open the SQL Server and create new database and tables etc... I opened the full path of the exe files "C:Program FilesMicrosoft SQL Server90ToolsBinnVSShellCommon7IDE" but there are not any file there, even that I searched for the exe files names but they are not existed. It looks that after instalation complete that the SQL Server is not installed on Windows Vista.
So, my question is: After installing the SQL Server 2005 SP2 for windows Vista, will the problem be solved? Or there is something else to do ON WINDOWS VISTA.
Please, I need the answer for this problem, because I need to work on SQL Server 2005 very hard.
Thanks in advance for your help...
View 11 Replies
View Related
Jul 24, 2007
I cannot find any specific info on the support of SQL server 2005 developer edition on different Windows Vista. Does anyone have any experience? TIA
View 3 Replies
View Related
Jan 18, 2008
Has microsoft issued an update so I can install SQL 2005 DE on Windows Vista? Thank You!
View 3 Replies
View Related
Jul 25, 2007
Hi
I have just take my system back to the factory defaults after some unsuccessful attempts to install 64 bit and 32 bit sql server on my notebook. I am looking to use either 32 or 64 bit (I have disks for both) and I would like to get a step by step guide that will help me through the process.
I tried an install of the 64 bit version, applied SP2, and it went smoothly but the report services browser didn't work. I tried to change some IIS settings but I didnt document what I changed so i was unable to undo the changes that i made when these didnt work.
I tried several combinations of things but then decided that a clean install on a clean system was the best option.
I need the SQL engine , reporting services, analysis services - and possibly integration services - i am not sure if i need notification services (dont know what it does anyway!)
I also have vs2005 - should i install that first or after sql server 2005 SP2?
Thanks
Doug
View 1 Replies
View Related
Dec 18, 2006
Hi there,
Can someone tell me what I need to get Express on Vista, I see a lot of contradictory information. Michael Otey notes in his column SP1, but then I here SP2.... Do I have something I can run today ...if not when..
Thanks.
View 4 Replies
View Related
Sep 6, 2007
Hi y'all,
I just know that SQL Server Express Edition SP2 is being released by Microsoft recently, and from previous informations I gathered; it seemed that SQL Server 2005 Express Edition is not compatible with Windows Vista (any editions).
With the release of SP2, does this mean SQL Server 2005 Express Edition is now compatible with Windows Vista?
If so, do I have to install .NET Framework v2.0 first in my Windows Vista Business edition? BecauseI know that Vista Business edition already has .NET Framework v3.0 in it.
Thanks for your help! Appreciate it...
View 14 Replies
View Related
May 1, 2007
Sorry.. but.. sql server express has compatibility with windows vista????
View 1 Replies
View Related
Apr 8, 2007
ok, today i upgraded to Vista, but i can't create database.
create database permission denied in database master. ("Microsoft sql server Error 262")
it must be the Vista thing because i don't have any problem with xp. yes, i the patch installed. I use SQl server management studio with Windows Authentication
View 4 Replies
View Related
May 31, 2007
Is it possible to install sql express on a 2 cpu Vista pc, even though this is stated to NOT be supported, by assigning CPU affinty, e.g., something similar to c:windowssystem32cmd.exe /C start /afinity 1 notepad.exe?
View 5 Replies
View Related
May 21, 2007
Hi All,
I have developed an windows application using C#. I am using SQL Express as back-end.
I have created an installer class which first installs .NET Framework2.0, SQL Express2005 and then the
application. It is woking fine with WindowsNT and XP oprating systems.
If i try to install this on Windows Vista OS, I am getting expection while installing SQL Express(Creating SQL
Instance).
Can anybody help me in this scenario.
Regards,
Doppalapudi.
View 3 Replies
View Related
Sep 1, 2006
Is there some special settings, permissions, or special choices I have to make when install SQL Express SP1 Advanced on Vista Beta 2 to allow me to restore DBs?
I have a user, which is the user during Vista Beta 2 install that it created as 'Administrator' account.
With this user, I have righ-clicked and Run As Administrator the SQL Express SP1 Advanced install..
All my attempts as an Administrator or with this user to restore a DB, results in a DB that the user can't connect to and run a simple select on. I either flat out can't restore the DB, or if I can somehow through lots of messing around get the DB restored, I then get a SQL permissions on object error from SQL Server Express on a simple select.
I don't know what I'm doing wrong, does anyone have any experience with this and any pointers on where I could be getting hung-up?
View 4 Replies
View Related
Apr 5, 2008
As the titel suggests I am having quite a strange problem
I have installed an Enotebook on our domain server at work and it uses MSQL express 2005.
When I ask it to automatically connect using window authentication to connect it works on windows XP machines with DomainUSERNAME. However when I try the same thing on Windows vista it tells me the logon failed with "DomainUSERNAM". I change it to SQL Authetifcation and type the same username fully (I have added the user via active directory as a SQL user) then it works
Basically it looks like the windows username is sent from Vista missing the last letter.
I have Googled this a lot and have not really found an answer. Am I mearly being very stupid or is this a known issue. Can anyone give me a suggestion as to why this might happen?.
View 5 Replies
View Related
Mar 27, 2007
Hi,
I have the following scenario in my lab:
1. Windows Vista Ultimate with an fresh SQL 2005 Express SP2;
2. Developer machine with Windows XP and SQL Manag. Studio.
Problem:
Windows Vista isn't allowing a SQL connection from XP >> Vista.
I've tried:
1. Configured surface area (the same configurations works on XP);
2. Configured all services and windows firewall base on online docs from MS.
After 6 hours arround i didn't find any solution. Any ideas?
View 3 Replies
View Related
Jun 12, 2006
Miscrosoft SQL Server Management Studio Express (SQLServer2005_SSMEE.msi) don't complete setup on Windows Vista Beta 2 with Sql Server 2005 Express installed.
Error Code 29506.
C:Program FilesMicrosoft SQL server\90Tools,
Alberto
What mean (Alberto is my Windows account)?
View 21 Replies
View Related
Sep 12, 2007
Hello,
Firstly, can someone confirm that this can be done. Because I am starting to wonder.
I have downloaded the SQL Server 2005 Express install, and attempted to install. Everything goes well. Computer scan indicates that everything is in place, but then when it goes to install the components it states that the following components failed:
- SQL Native Client
- SQL Server Database Services
- Reporting Services
- Workstation Components, Books Online
(Successful items were SQL Setup Support Files, SQL VSS Writer, OWC11, SQL Server Backward-Compatibility Files, SQL Server Management Studio Express).
For those Items that failed, I just get a message stating "Setup failed. Refer to Setup Log'. The setup log tells me little to nothing about why these components failed.
I am also getting the following message part way through install "An installation package for the product Microsoft SQL Server Native Client cannot be found. Try the installation again using a valid copy of the installation package 'sqlncli.mis'". Does anyone know what this means? I downloaded the install from microsoft.com just a few days ago, so if this isn't "valid", then where do I get a valid one.
I'm totally stuck. Have spent almost a day trawling documentation etc. to find why these have not installed, but cannot find any indication of why they wont install.. everything that needs to be in place is. Hoping someone has had similar issues and can help.
Many Thanks in Advance.
View 1 Replies
View Related
Nov 27, 2006
I want to create deployment for MS SQL 2005 Express database, that
creates database, tables and inserts data. I have made a similar with
VisualStudio 2003 and MSDN
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnmsde/html/msdedepl.asp?_r=1
For Windows Vista it won`t work. I have tried to create with
Visual Basic 2005 Express, but I didn`t get how can I do it with
ClickOnce.
If you can help me, I`ll bee thankful!!!!
View 2 Replies
View Related
Mar 12, 2007
Hi,
Im encountering yet another problem in Vista(Vista Home Premium). I have turned on all IIS features from control panel. When I open http://localhost it gives the error
HTTP Error 404.4 - Not Found
Description: The resource you are looking for does not have a handler associated with it
How should i resolve this?
Also, when I try to install SQL server 2005 express edition, it gives the warning that IIS is not installed, though I have installed all the features and it is running.
I have been struggling for the past one week, just to install SQL server on vista!
Please help.
Thanks
View 4 Replies
View Related
Jan 23, 2008
Good day all, I wanted to get some feedback on what I think may be an issue between SQL Server 2005 Express and Vista. Specifically I use Vista Business edition and I was trying to execute the same bit of code on two different machines with the same exact database. The ONLY difference was Vista. See code below...what I doing in XP Professional SP2 was inserting an image into a table. This worked well on XP but the same code failed to actually insert the image. A row was created in 'myTable' but not binary data from the image insert. Can someone please advise or help me - it goes without saying that I an quite frustrated. ;-)
CREATE TABLE myTable(FileName nvarchar(60),
FileType nvarchar(60), Document varbinary(max))
GO
INSERT INTO myTable(FileName, FileType, Document)
SELECT 'titleist-dtsolo.jpg' AS FileName,
'.jpg' AS FileType,
* FROM OPENROWSET(BULK N'C:UsersBrian EvansDesktopgolfPremiumsgolfPremiumsProjectWebImages itleist-dtsolo.jpg', SINGLE_BLOB) AS Document
GO
Selecting from the results yields a row with no image data, and I did verify the path and image before and after running this sample.
View 6 Replies
View Related
Sep 22, 2007
Hi!
I am getting error when trying to install SQL 2005 express edition on Windows Vista (32-bit). It says that I don't have the framework (or it's corrupt), but I know that i don't need to install it again because it cames already with Vista.
I tried to install the framework, but it says that i've already the framework installed.
Any help or pointers would be greatly appreciated.
Thank you!
Monica
View 1 Replies
View Related
Mar 10, 2007
Hi,
Past one week I have been struggling to install SQL server express edition on my laptop which is preinstalled with Vista Basic. After it commences installation, it says the .net 2.0 on the system in corrupted.
Please let me know how to proceed ASAP... i have a project due for submission this week!
Thanks
View 6 Replies
View Related
Nov 18, 2006
Hello NG,
After installing SQL Server 2005 Express Edition on Windows Vista RC1, I wanted to install also the Managent Studio but I always receive the following error message:
"Bei der Installation dieses Pakets ist ein unerwarteter Fehler aufgetreten. Es liegt eventuell ein das Paket betreffendes Problem vor. Der Fehlercode ist 29506."
Where can I find more infos about this error-code?
Anybody knows this problem?
Thank in advance for every help.
View 76 Replies
View Related
Apr 11, 2008
I have been through virtually every last posting on installing SQL Server Express with Advanced Services in this site and still have no success accessing the Reporting Services site: http://localhost.reports$sqlexpress. I get a the correct background to the site as in the tutorials, but only get "ERROR - unable to connect to the remote server", which may be indicative because this is all installed on my local machine (Dell AMD Athlon 64 X2 Dual Core 4000+ 2.11 Ghz, 1GB, Windows Ultimate). I have gone through How to install ... on a Windows Vista-based computer, KB934164, and most recently, How to configure .. to allow remote connections, kb 914277, in hopes of addressing the "remote server" issue. I still can't get past this obstacle. PLEASE HELP!! :-)
View 11 Replies
View Related
Apr 13, 2007
Steps to install SSX (& Reporting Serivces) on 64 bit Windows Vista Ultimate
I struggled quite a bit over the past few days to complete this install. The sequence of steps is less obvious than those for Windows XP Pro on a 32 bit machine.
I recorded all the steps in one place in cookbook style for non-technical (but database capable) users like myself. I have referenced appropriate other postings and sources for detail steps. These are steps I found useful, you may be in a different situation.
My environment is as follows:
-New HP dv9000 w/ 2GHz and 2GB memory
-Factory installed Windows Vista Ultimate. Note this includes .NET Framework 2.0 so I did not have to deal with installing that.
-I have no extant databases or SQL Server that I am trying to convert or upgrade!
Setup Steps Before Install:
1) Turn off User Account Control.
At present, I am a one-user operation with close control over my system and there seemed to be issues with getting reporting services set up right with UAC. I may come back and modify this step later on and certainly would change this for any releasable systems.
1a)Go to Control Panel Home --> User Accounts --> Turn User Account Control on or off.
1b)Unselect Use User Acount Control.
2)Set up your IIS 7.0 for Reporting Services.
IIS 7.0 has IIS 6.0 Compatibility features turned off out of the box. You will turn them on with this step. This is needed for both Reporting services and to enable the Adminscripts that are used in Step 3 below.
2a) Use the Control Panel --> Programs --> Turn Windows features on and off function.
This is quite nicely desribed with screen shots at:
http://www.iis.net/default.aspx?tabid=2&subtabid=25&i=957
These steps worked for me although they are labeled Vista Beta 2.
3)Set up your 64 bit machine to run 32 bit ASP.NET
This capability is needed to make sure you pass the System Configuration Check for Reporting Services. I don't know the full implications of this step and wonder if it might eventually bite me if I have to flip-flop between 32 and 64 bit ASP.NET or have them both run at the same time.
3a) Open a command line window by:
Start --> Accessories -- Cmd Prompt
3b) In this window type:
cscript %SystemDrive%inetpubAdminScriptsadsutil.vbs set w3svc/AppPools/Enable32bitAppOnWin64 1
At some point, you may wish to go back to 64 bit. For that, see the posting by MihaelaE as an Answer in the SQL Server Reporting Services Forum under a thread started by fagster on 3/8/2007.
Now to actually install SQL Server.
1) Download the 64 bit SSX.
This step fooled me for a while as the 64-bit downloads are 'below the fold' on the web page.
1a) Go to the SSX download page:
http://msdn.microsoft.com/vstudio/express/sql/download/
1b) Scroll down the page and below Step 5, Register, you will see this text which takes you to the download you want:
"* For the 64-bit install of SQL Server 2005 Express Edition, click here."
1c) Follow the "click here" to get the download.
2) Install the package from step 1c and you will get SQL Server Express.
2a) The install may fail and complain about not finding a valid SQL Server Native Client Install, sqlncli_x64.msi. You will have to extract the files manually and then run the sqlncli_64.msi package by itself. Then you can go back to step 2 and should be successful.
To do this, see post of Mike Wachal on 4/5/2007 to SQL Server Express Forum, titled "Cannot Install SQL Server Express on Vista Ultimate -- cannot find MS SQL Server Native Client".
3) Now add in the SQL Server Management Studio Express 64 bit version.
3a) Go to the SSX download page:
http://msdn.microsoft.com/vstudio/express/sql/download/
3b) Scroll down the page and below Step 5, Register you will see this text which takes you to the download you want:
"* For the 64-bit install of SQL Server 2005 Management Studio Express, click here."
3c) Follow the "click here" to get the download.
4) Now add the SQL Server Reporting Services.
4a) Go to the SSX download page:
http://msdn.microsoft.com/vstudio/express/sql/download/
4b) Scroll to Step 3 Download and Install (in the middle of the page) and download SQL Server Express Edition with Advanced Services SP2.
4c) Install, but at the Feature Selection screen, disable all components EXCEPT Reporting Services. You already have the other components installed.
4d) In the install, you will get a screen called "Report Server Installation Options". Go ahead and select the "Install but do not configure the server" radio button.
5) Go ahead and configure SQL Server Reporting Services.
I'm not highly skilled in this area so I recommend the SQL Server Express Video "Learning Video 10: Getting Started with Reporting Services". This is found at: http://msdn.microsoft.com/vstudio/express/sql/learning/default.aspx
I found this video to be cogent and useful.
That's what it took me to get SQL Server Express installed with reporting services on a 64 bit Vista Ultimate system. Sorry if this is so long but I wanted to cover all the steps that hung me up.
To forum moderators: If I have any errors that will lead people astray, I'm more than happy to correct them.
This posting is "AS IS" with no warrantees and caveat emptor.
View 1 Replies
View Related
Jul 17, 2006
I have a Sql Server Express Edition instaled in a Windows 2003 Server. I will use SQL Authentication. Need I Cal's for Windows 2003 server to each user that will access the SQL Express ? If yes, why ?
View 5 Replies
View Related
Mar 8, 2006
Hi,
I am trying to install SQL Express on Window Home XP and SCC is returning the following error:
The SQL Server Configuration Checker cannot b execute due to WMI configuration on the machine ..... Error 2147942405 (0X80070005).
I tried running the following batch file which I believe resolved the same issue that someone else raised earlier (though I am not sure whether the OS was Home XP)
Will upgrading from XP Home to XP Professional (academic version) help me install SQL express successfully>
The Batch file I ran looks like this:
FIXWMI.CMD
------------------------
@echo on
cd /d c: emp
if not exist %windir%system32wbem goto TryInstall
cd /d %windir%system32wbem
net stop winmgmt
winmgmt /kill
if exist Rep_bak rd Rep_bak /s /q
rename Repository Rep_bak
for %%i in (*.dll) do RegSvr32 -s %%i
for %%i in (*.exe) do call :FixSrv %%i
for %%i in (*.mof,*.mfl) do Mofcomp %%i
net start winmgmt
goto End
:FixSrv
if /I (%1) == (wbemcntl.exe) goto SkipSrv
if /I (%1) == (wbemtest.exe) goto SkipSrv
if /I (%1) == (mofcomp.exe) goto SkipSrv
%1 /RegServer
:SkipSrv
goto End
:TryInstall
if not exist wmicore.exe goto End
wmicore /s
net start winmgmt
:End
Any suggesstions will be geatly appreciated.
View 4 Replies
View Related
Oct 25, 2007
I have:
A server computer running SQL Server 2005 Enterprise Edition.
A industrial computer running SQL Server 2005 Express Edition.
And now also a Psion WorkAboutPro with CE 5 that should run SQL Server Compact Edition.
The industrial computer syncs its data with the server, basically saying "this has happened".
Now I want the Psion to sync with the industrial computer, but this sync must two-way.
I have tried to find a guide or something that can tell me "do this to sync" but the information i have found is sketchy at best.
If someone could point me in the right direction of a guide or something else it would be much appreciated.
Regards,
Björn
View 9 Replies
View Related
May 10, 2006
I Try to install SQL Server Express in Windows 2003 Standard edition x64 and have some problems.
It say that can not instal client and say to use sqlncli_x64.msi, but I can not find this packege to install this client and I receive one alert with ASP.NET register 64.
I Check all request systems requirements many times and looks ok.
How can I solve this to install properly the SQL 2005 Express? When the setup finish say that was not possiblem to install SQL Server 2005 Express.
Regards
Leandro
View 1 Replies
View Related
Mar 14, 2007
Hi everyone...
I'm facing a problem while installing the SQL Server 2005 Express on Windows 2000 Pro with SP4.
After finishing the downloading from Microsoft I start the installation and things seems to go ok but during Extracting Files step a message appears "SQL Server Setup unexpectedly failed. For more information, review the setup summary log file in %Program Files%Microsoft SQL Server90Setup BootstrapLOGSummary.txt" and it terminates the installation.
I located the log file and open it but can't understand the problem..I copy the text and paste it here for anyone who can understand it.Please, it is very importand for me to work with SQL Server for my project. Any advice or information or anything else???
Thank you all,
HERE IS THE LOG FILE:
"Microsoft SQL Server 2005 Setup beginning at Wed Mar 14 07:45:33 2007
Process ID : 2684
c:c7720b32114815db82783dd06c2d54b9setup.exe Version: 2005.90.3042.0
Running: LoadResourcesAction at: 2007/2/14 7:45:33
Complete: LoadResourcesAction at: 2007/2/14 7:45:33, returned true
Running: ParseBootstrapOptionsAction at: 2007/2/14 7:45:33
Loaded DLL:c:c7720b32114815db82783dd06c2d54b9xmlrw.dll Version:2.0.3609.0
Complete: ParseBootstrapOptionsAction at: 2007/2/14 7:45:33, returned false
Error: Action "ParseBootstrapOptionsAction" failed during execution. Error information reported during run:
Could not parse command line due to datastore exception.
Source File Name: utillibpersisthelpers.cpp
Compiler Timestamp: Wed Jun 14 16:30:14 2006
Function Name: writeEncryptedString
Source Line Number: 124
----------------------------------------------------------
writeEncryptedString() failed
Source File Name: utillibpersisthelpers.cpp
Compiler Timestamp: Wed Jun 14 16:30:14 2006
Function Name: writeEncryptedString
Source Line Number: 123
----------------------------------------------------------
Error Code: 0x80070002 (2)
Windows Error Text: Error: Action "ActivateLoggingAction" threw an exception during execution. Error information reported during run:
Datastore exception while trying to write logging properties.
Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupStateScope.primaryLogFiles
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupStateScope"
02B1CFC0Unable to proceed with setup, there was a command line parsing error. : 2
Error Code: 0x80070002 (2)
Windows Error Text:
Class not registered.
Failed to create CAB file due to datastore exception
Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:27:59 2006
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "HostSetup" {"SetupBootstrapOptionsScope", "", "2684"} in cache
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Wed Jun 14 16:28:01 2006
Function Name: SetupBootstrapOptionsScope.HostSetup
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupBootstrapOptionsScope"
Message pump returning: 2"
View 4 Replies
View Related
Mar 26, 2008
Hallo there,
I just upgraded from Windows XP Pro to Windows Vista Bussiness and tried to reinstall SQL Server 2005 Developers Edition. After the installation i downloaded (using microsoft windows update) and installed all the service packs for sql and vista available.
My problem is when i open sql server management studio and try to connect to my default instance using windows authentication and database engine, an 18456 error occurs.
I enabled all the protocols and all the ports
I disabled windows firewall and antivirus (eset nod32)
I installed all service packs available
I have also installed Visual Studio 2005 without installing sqlexpress
But nothing happens!
Please i am very desperate, any information will be gratefully accepted.
This is my installation Information
Code Snippet
Microsoft SQL Server Management Studio 9.00.3042.00
Microsoft Analysis Services Client Tools 2005.090.3042.00
Microsoft Data Access Components (MDAC) 6.0.6001.18000 (longhorn_rtm.080118-1840)
Microsoft MSXML 3.0 5.0 6.0
Microsoft Internet Explorer 7.0.6001.18000
Microsoft .NET Framework 2.0.50727.1434
Operating System 6.0.6001
Thank you in advance,
Patonios
View 3 Replies
View Related