i want to create enterprise geodatabase using sql server i already have oracle platform but i choose not to use it because sql seems much lighter ......the problem is it seems that the sqlserver are not connected or cannot be accessed by arcserver .....because the sde user is not on the log in of any database in oracle second of all when i tray to creat a geodatabase it give me the following
Note :
Arcserver 10.2.2
arcmap 10.2.2
Sql server 2014 Enterprise
all 64 bit
It looks like you are not able to access sqlserver "hassasvr" from this client box using sa user. can you please try to connect to this sqlserver from this Arccatalog using the same parameter as on screen capture 1. Also check the spelling of sql server name.
i found the issue that i should write the whole sqlserver instance ..ex AHCEC-gis-H\hassasvr
Also send or copy the content of sde log and setup log file. We can find more information from those files.
Adding some more people to the picture
https://community.esri.com/groups/geodatabase?sr=search&searchId=ead6f540-931c-47f8-918f-0da1fe3bc72... https://community.esri.com/community/gis/enterprise-gis?sr=search&searchId=8ad9e752-2234-49c3-9e6e-f...
From the screen capture it looks like you're putting the incorrect SQL Server instance name into the 'Instance' parameter of the tool. You'll need to put the fully qualified name (AHCEC-GIS-H\HASSASRVR) in order to access the SQL Server instance
Quinn